Forum Discussion
Advocate IIHow to use DirectQuery table with complex visuals
Hi Petja ,
Sorry for the delay in response.
Yes. If Performance Analyzer doesn't expose the query because the visual fails, you can capture it from the Power BI Desktop trace.
Go to File → Options and settings → Options → Diagnostics → Open crash dump/traces folder. Then locate the active AnalysisServicesWorkspaces folder and open FlightRecorderCurrent.trc.
If the source is SQL Server, you can also use SQL Server Profiler to capture the query directly at the database side.
Thanks!!
Advocate IIThank you for a very detailed response. This is in line with what my understanding was of the subject but unfortunately my organisation does not provide the correct tools for optimizing the workflow. I should do all heavy lifting before power BI but unfortunately I am not able.
If you know how to capture the sql statement of a failed visual, would be much appreciated.
Community SupportHi Petja ,
Sorry for the delay in response.
Yes. If Performance Analyzer doesn't expose the query because the visual fails, you can capture it from the Power BI Desktop trace.
Go to File → Options and settings → Options → Diagnostics → Open crash dump/traces folder. Then locate the active AnalysisServicesWorkspaces folder and open FlightRecorderCurrent.trc.
If the source is SQL Server, you can also use SQL Server Profiler to capture the query directly at the database side.
Thanks!!
- v-sathmakuri
Hi Petja ,
Could you check the suggestion provided above and let us know if you have any additional queries?
Thanks!!
- v-sathmakuri
Hi Petja ,
Could you review the suggestion provided above and let us know if you have any additional questions, we are happy to address.
Thanks!!