How to view the SQL generated by a power bi report

[AnandNamburi]

Hi All,

I have build a report in Power BI desktop.

If I want to know/see the backend SQL generated by the report how can I acheive it.

Thanks,

Anand

[arichard19]

You could use the SQL Profiler - https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-v...

Or possible DAX studio for you DAX measures - https://www.sqlbi.com/articles/analyze-directquery-requests-using-dax-studio/

If you are running a NATIVE query in Power Query you can right click on any step in your Power Query Windows and select "View Data Source Query"

Which will return the SQL code to you

[goncalogeraldes · Accepted solution]

Hello there @AnandNamburi ! You can use the "View Native Query" option in Power QUery if query folding is possible on your queries generated in Power Query. 

You can refer to the following documentation as support to your question:

https://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes