Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Salonic
Resolver I
Resolver I

Power BI desktop : Query Log

Hello,

 

In PowerBI DeskTop, when querying in a cube SSAS in mode import, is there any possibilities to see what are the queries send to SSAS ?

 

We are facing some performance problems in using PowerBI DeskTop and we try to see what are the queries sending to SSAS.

When using the SSAS trace events we are polluted by other queries that are not send from PowerBI DeskTop and it is hard to analyse the logs.

 

Thank you for your help,

 

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@Salonic

 

There's no query log on Power BI side. You may try to generate Trace for long queries via Power Query. See:

 

https://blog.crossjoin.co.uk/2016/06/09/power-bi-diagnostics-trace-logs-and-query-execution-times-ag...

 

However, you can use SQL Profiler to monitor the Query sent to SSAS server. You just need to filter the ApplicationName like "Power BI" in column filter to show events related to Power BI only.

 

9.PNG

 

Regards,

View solution in original post

1 REPLY 1
v-sihou-msft
Employee
Employee

@Salonic

 

There's no query log on Power BI side. You may try to generate Trace for long queries via Power Query. See:

 

https://blog.crossjoin.co.uk/2016/06/09/power-bi-diagnostics-trace-logs-and-query-execution-times-ag...

 

However, you can use SQL Profiler to monitor the Query sent to SSAS server. You just need to filter the ApplicationName like "Power BI" in column filter to show events related to Power BI only.

 

9.PNG

 

Regards,

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.