Forum Discussion
View All Data Sources for all Datasets published to Power BI Service
Hi Anonymous ,
Yo ucan retrieve this information using the API functionality along with Power BI. That information can be found here:
Power BI REST APIs - Power BI REST API | Microsoft Docs
And, specifically, I think you are looking for this one here: Admin - Datasets GetDatasetsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Thank you collinq !
The one issue I see with this route is that it gives me the name of the table based on how the user pulled it into their .pbix.
For a crude example:
My source table is called AllCustomers
Dataset1 pulls it into .pbix and names it "CustomerTable"
Dataset2 pulls it into .pbix and names it "My Customers"
Using the API I won't be able to identify that 2 users are pulling from the same AllCustomers table (since it will show as 2 different tables)
Hey Anonymous ,
Hmmmmm, well, maybe this one then - that gives the datasource and not just the name?
Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs