Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Finding generated query against XMLA endpoint in Query Diagnostics

I am trying to build a query against an existing Power BI report so I can run it in another application.   I connected to the XMLA endpoint for the existing report and have applied some steps in Po...
Need Help
Tutorial Requests
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

If you apply any transformation in Power query, it can show some information after enabling Query Diagnostics.

Please refer to the details how to record diagnostics:

https://docs.microsoft.com/en-us/power-query/recordingquerydiagnostics

 

"I connected to the XMLA endpoint for the existing report",

based on my knowledge, to use XMLA endpoint in Power BI means to use tools below to connect to power bi datasets.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools#data-modeling-and-management-tools

This behavior may not genarate dianostics logs.

If you use SQL server tools, you can run SQL Server profile to capture what queries runs when connecting to power bi dataset.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
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
    6 years ago

    Maggie, as specified above, I have enabled Query Diagnostics. In the resulting logs, the "Data Source Query" column is not populating. This column would normally contain text sent to the server.

     

    Thank you for the recommendation to use SSMS. I will give that a try.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, v-juanli-msft. I was able to use the SQL Profiler to get the folded query text sent to the server.

    As a note, it's important to specify the database name when connecting to the server, it does not suffice to use a filter on the trace itself.