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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Need Power BI rest api which list all data source from all the sematic model

Need Power BI rest api which list all data sources from all the sematic model at tenant level

Status: New
Comments
zllll
Regular Visitor
You get all query definitions from your PowerQuery of the model with Power BI API using https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries this and running DAX code of "EVALUATE INFO.PARTITIONS()" or you could use Semantic link to run the same DAX query as described here: https://learn.microsoft.com/en-us/fabric/data-science/read-write-power-bi-python I know that this is not a list of data sources, but you could easily parse the M code and then figure out what table is loaded from where.