Forum Discussion
Helper IIIHow to view the SQL generated by a power bi report
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
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
2 Replies
- goncalogeraldes
Super User
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 
arichard19Resolver I
You could use the SQL Profiler - https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver15
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