Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
8 years ago

View SQL query in direct query mode

Is there anyway to view the SQL generated by Power BI desktop for direct SQL queries?   Thanks!
Need Help
OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
8 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

OneWithQuestion,

We are only able to view Native query in Query Editor of Power BI Desktop.

In addition, regarding to the XML 15 definition issue, I will consult it internally and post back.

Regards,

Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Any progress on this? Using SQL Server Profiler 18 and opening traces from Power BI gathered via XMLA endpoint throw the error "Unable to locate trace definition file"