Forum Discussion
Monitoring queries from Power BI Service using Extended Events in SSMS
Hi,mmcanelly
After connecting to SQL Server Profiler, you need to open the corresponding report in Power BI Service and click refresh in the upper right corner.
Then go back to SQL Server Profiler to find the statement in the red box.
And then pull the SQL statement to the bottom to find the DatasetId.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous, I followed your steps, but I'm not seeing the DatasetId or any of the other fields that you show in your screenshot. Mine is just showing the query that ran from the Power BI refresh, without any additional information to identify the dataset.
Did you have to set something additional up in Power BI to include the dataset ID when it sends the query?
Hi,mmcanelly
After connecting to SQL Server Profiler, you need to open the corresponding report in Power BI Service and click refresh in the upper right corner.
Then go back to SQL Server Profiler to find the statement in the red box.
And then pull the SQL statement to the bottom to find the DatasetId.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.