Forum Discussion
chiaracaspani
Advocate I
Advocate ICheck generated SQL query
Hi all, since when i import data in my power bi report i am able to specify a sql query in the advanced options, i would like to know if is it possible to do the opposite thing: to import a dataset ...
Hi chiaracaspani,
There is a feature called View Native Query in desktop for us to check backend T-SQL query. See: Power BI – Checking Query Folding With View Native Query.
Best Regards,
Qiuyun Yu
Dreamer_Argento
Helper I
Helper IDoes anybody know how to see entire SQL Statment generated by Power BI (including WHERE, JOIN, GROUP BY ...).
Some answers of this post explain how to see the standard SQL Statment (select field1, field2 ... from table) but not includes relationships between tables, grouping, ...
Thank you for your attention to this matter.