The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.
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.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
7 | |
4 | |
4 | |
3 | |
2 |