cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeKK
Helper III
Helper III

Underlying data source of a Power BI datasets

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?

 

 

1 ACCEPTED SOLUTION

Hi @MikeKK ,

 

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

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

5 REPLIES 5
collinq
Super User II
Super User II

Hi @MikeKK ,

 

In the service you can use the lineage view and that should help you.




Did I answer your question? Mark my post as a solution!

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?

 

f.png

Hi @MikeKK ,

 

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:

 

collinq_0-1624031348906.png

 

is that not doing what you need?




Did I answer your question? Mark my post as a solution!

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

 

Untitled.png

Hi @MikeKK ,

 

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

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors