Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ClaraPS
New Member

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

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

2 REPLIES 2
josef78
Memorable Member
Memorable Member

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
Super User
Super User

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.