Forum Discussion
View SQL query in direct query mode
To clarify on Native Query: That only works for the ETL stage right? When I an viewing the edit query screen and seeing the "raw data tables" returned and the various steps from the source (like renaming columns, adding calculated columns etc...)
How can I view the "native query" for a table on the visual designer?
In my scenario I am placing a table on the visual layout page and adding a filter and want to see what query it is sending back?
Second question:
WHY is PowerBI using a version of profiler that is not available?
Where do we get that XML 15 definition?
To see the query that is generated for a visual, go to View --> Performance analyzer. Click Start recording, and Refresh visuals. Once the visual has been refreshed, click Stop. Then click Copy query and paste in Notepad++, etc. This query contains both DAX and SQL (for DirectQuery tables).