Forum Discussion

abpgupta's avatar
abpgupta
Continued 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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

abpgupta - What do you mean by "all SQLs"? SQL tables? Stored procedures? ?

abpgupta's avatar
abpgupta
Continued Contributor
5 years ago

Hi Greg_Deckler ,
I meant to capture all Native Queries sent to Database while running refresh.

Thanks!

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, abpgupta 

    If you are querying a relational database, especially SQL Server, then you want to make sure that query folding is being applied. Query folding is when M code in PowerQuery is pushed down to the source system, often via a SQL query. One simple way to confirm that query folding is working is to right click on a step sand select View Native Query. This will show you the SQL query that will be run against the database.

    You can also view related queries through SQL Server Profiler.

     

    For more details,please check the part of this document about determining-the-queries-sent-by-power-bi-desktop.

     

    Best Regards,
    Community Support Team _ Eason