Forum Discussion
View Original SQL statement on Power BI desktop
Hi, Bokchoy
According to your description, your dataset is created by SQL statement, which means that you have placed some SQL statement here, right?
If so, I guess that is the reason why your “native query” option is greyed out.
Power Query cannot fold if you do that. If you want to do your own SQL plus have PQ fold more stuff, you need to create a view on your server and connect to that, or create ALL transformations in Power Query.
What’s more, one step in your query disabled “view native query”, the rest also can’t support it anymore. You can refer to this document to learn the reasons why query folding is disabled:
https://docs.microsoft.com/en-us/power-query/power-query-folding
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Im so confused as to why there are so many responses narrating what and how to use query folding. That was not the question. The question is to view the original SQL statement. I have a report that uses a SQL statement, and I would like to view it to see its operations.