How to find exact time of query submission from Po...

Anonymous · ‎07-25-2021

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

v-janeyg-msft · ‎07-27-2021

Hi, @Anonymous

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 · ‎07-25-2021

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!