Forum Discussion

mmcanelly's avatar
mmcanelly
Helper II
2 years ago
Solved

Monitoring queries from Power BI Service using Extended Events in SSMS

I'm working on setting up monitoring of my queries from the Power BI service to SQL Server each time a semantic model refreshes. I'm using SSMS v18.12, and it looks like Extended Events in SSMS can d...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,mmcanelly 

I am glad to help you.  

 

According to your description, you want to know how to identify which semantic model a Power BI Service request is coming from? 

 

If I understand you correctly, then you can refer to my solution. 

 

You can use SQL Server Profiler for tracing, through which you will get the DatasetId, ReportId, and VisualId corresponding to the executed operation: 

 

 

 

Then in the address bar of Power BI, you can find the corresponding DatasetId. Corresponding the DatasetId, you can see which semantic model your request in Power BI Service corresponds to. 

 

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.