Obtain all queries user in pbix hosted in power bi report server

[ClaraPS]

Hi,

I would like to know if there is any way to extract from the power bi report server database or by using the power bi report server api the list of queries used in the reports hosted on power bi report server.

Thansk in advance

[josef78]

There is not standard way how extract dataset source queries (SQL or M), it is not included in standard API 😞

But there are two workarounds, but more complicated. 

-Is possible extract blob of pbix file, and from this file is possible extract source definition

-Or is possible connect to SSAS running under PBIRS, and using DMV extract source definition, which is more easy

Also propably exist 3rd party data-lineage tools which are able extract source definiton.

[d_gosbell]

Unfortunately the answer is no. There is no API for this and the pbix files are stored as blobs in the database so you cannot extract the query text from there.