Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have inherited a bunch of reports from an ex-coworker. These reports use Power BI datasets as dataset. I want to find out what is the actual data source that the report is using.
The pbix file does not give any clue since there is no data tab. If I click on "Transform data" ->"Data Source Setting", it brings me to add another Power BI dataset to the reports.
Is there anyway I can find out the underlying actual data source of the Power BI datasets?
Solved! Go to Solution.
Hi @Anonymous ,
Hmmmmm, maybe you should try the API and the get dataset or get datasources.
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Anonymous ,
In the service you can use the lineage view and that should help you.
Proud to be a Datanaut!
Private message me for consulting or training needs.
hi @collinq lineage view shows the dataset of the report used, but what is the underlying data source of the dataset?
See screenshot below There is no option to view the underlying datasource.
Is it something hidden and only viewable by Power BI tenant admin?
Hi @Anonymous ,
I am not sure but I think one of us is misunderstanding the other....
I am referring to this part of the lineage view that shows the underlying data source:
is that not doing what you need?
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq Unfortunately there is no underlying data source listed. I believe the dataset is created on Power Bi Service directly, not through Power BI Desktop
Hi @Anonymous ,
Hmmmmm, maybe you should try the API and the get dataset or get datasources.
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.