Finding generated query against XMLA endpoint in Query Diagnostics

[CamronBute]

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 Power Query. I used Query Diagnostics to see if I could see what the final, folded query was against the endpoint, but all the values in the "Data Source Query" column are blank.

How can I see the query that's being sent to the endpoint?

[v-juanli-msft · Accepted solution]

Hi @CamronBute 

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-mana...

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.

[CamronBute]

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.

[CamronBute]

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.