Forum Discussion

OneWithQuestion

Icon for Post Prodigy rank

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!

ricardocamargos

Icon for Continued Contributor rank

Continued Contributor

8 years ago

Hi OneWithQuestion,

Power BI Desktop creates a file "FlightRecorderCurrent.trc." on:

"\<User>\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces"

Or you can also enable it on the file -> options -> diagnostics

References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

Thanks,

Ricardo

OneWithQuestion
Post Prodigy
8 years ago
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
- ricardocamargos
  Continued Contributor
  8 years ago
  Hi OneWithQuestion,
  
  Which sql profiler's version are u using ?
  - OneWithQuestion
    Post Prodigy
    8 years ago
    2017, the one with SSMS 17.4
- Anonymous
  Not applicable
  8 years ago
  OneWithQuestion,
  
  Please update your SSMS from 17.4 to 17.5, then start the SQL Profiler trace in Admin mode, this way, you will be able to open the trace file.
  
  Regards,
  Lydia