Forum Discussion
View SQL query in direct query mode
So it appears that the trace files generated cannot be opened which is really odd.
When I go to open it with Profiler I get this error: Can't open PowerBI trace file: Needs TraceDefinition 15.0.0.xml
- 2017, the one with SSMS 17.4
OneWithQuestion,
Go to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Profiler\TraceDefinitions, you can find that the version of Analysis Services TraceDefinition xml file is 14.0.0, and this is the highest version of the file in SQL Server.
However, the trace file generated by Power BI Desktop requires Microsoft Analysis Services TraceDefinition 15.0.0.xml, thus you get the above error.
There are two workarounds for you solve this issue.
1. Use December update of Power BI Desktop to connect to your data source, the trace file generated by the version can be opened in your SQL profiler.
2. Use native query option in Power BI Desktop to check undelying sql query.
Regards,
LydiaTo 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?