Reputation: 6940
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.
Upvotes: 2
Views: 916
Reputation: 30289
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.
Upvotes: 4