Forum Discussion

abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Way to get all SQLs in Power Query Editor

Hi All   Is there any way to get all SQLs from Power Query Editor instead of going through each query and validate Transforms to get final queries.   Thanks for inputs here!        
Need Help
Tips and Tricks
  • edhans's avatar
    edhans
    5 years ago

    If you want to trap all native queries sent, capture them from the SQL Server abpgupta using a Server Side Trace.

abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
5 years ago

I think, PBI should provide ability to generate all SQLs it's sending to database similar to Cognos.