2

Is there a way to get the list of all SQL queries in the first step of all Power Query. Please note, I am NOT interested in the source paths (server/database) which can be accessed through Option/Sources settings.

Davide Bacci
  • 16,647
  • 3
  • 10
  • 36
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191

1 Answers1

2

In PowerBI Desktop, go to File -> About -> Copy session diagnostics to clipboard.

This will copy all your queries where you can then parse out the required SQL.

enter image description here

Davide Bacci
  • 16,647
  • 3
  • 10
  • 36