Forum Discussion
Tracing queries from published reports
It's possible that you may not be able to see the query activity from already published reports in the Service using the methods you have mentioned. This is because when a report is published to the Service, the queries are executed on the backend and not on the user's machine. Therefore, the queries are not captured in DAX Studio or SQL Server Profiler.
However, you can use the Power BI audit log to track activity in the Power BI service, including query activity against datasets. This log includes events such as "View report", "Export data", and "Create report" that can help you track usage of your published reports and datasets. To access the audit log, you must have Power BI administrator privileges.
You can also use the Usage Metrics feature in the Power BI service to track usage of your published reports and datasets. This feature allows you to view metrics such as views, interactions, and time spent in your reports. To access the Usage Metrics feature, go to the report or dataset you want to track, click on the ellipsis (...) and select "Usage metrics".
I hope this helps!
Hi Adamboer. Thanks very much for your reply and suggestions - but we are connecting to the dataset in the service using the XMLA endpoint (i.e. to the "backend"), so our understanding is that we should be able to see queries from reports using that dataset. Following further work it looks like some of the queries are now coming through, but not all and we keep timing out - so there is another issue at work. Thanks again, and will look at your other suggestions.