Forum Discussion
View Original SQL statement on Power BI desktop
Hi everyone,
I have a dataset constructed with a SQL statement. I can't seem to find the original SQL statement in query editor, anyone knows where I can find that.
Thanks
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.
7 Replies
Here is the answer to this question. Perhaps someone will find this information useful. To view the original SQL query passed into the report.
1.) Right click your query/fields on the right fields pane. Select edit query.
2.) In the Power Query Editor window that opens. Select the query you want to view. Then select the gear icon of the Source under applied steps
3.) View the original query
Bokchoy , In power query, Right click on the table, open advance editor. You should see SQL there
Hi amitchandak ,
The advanced query only shows me the applied steps that are used to transform the table. I'm looking for the native SQL query statement that was used to construct the table before its loaded into BI
Also when I right-click on the last applied step, the native query option is greyed out.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.
