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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kheranooh
Frequent Visitor

How to find exact time of query submission from PowerBI Service for Live Connection to SSAS

Is there a way to find out exact date time of DAX query submission from PowerBI Service for a live connection to Tabular SSAS ?

We suspect that there is a gap between the query fired from the PowerBI Service vs query received at SSAS. We have traces enabled on SSAS where we could see StartTime of the DAX query, but looking for something similar on PowerBI Service. 

 

-Sachin

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @Kheranooh 

 

Audit logs can't retrieve dax queries. If the data is local, you can use the fidder tool to detect all the query information sent when the report is interactive, including the query time.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

vanessafvg
Super User
Super User

have you looked in the service audit  logs which will be stored on the 365 audit log but you can see a lot of the different activies there

https://protection.office.com/unifiedauditlog

search for  power bi 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors