Forum Discussion

Bokchoy's avatar
Bokchoy
Helper II
5 years ago
Solved

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
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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