Underlying data source of a Power BI datasets

[Anonymous]

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?

[collinq]

Hi @Anonymous ,

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

[Anonymous]

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?

[collinq]

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?

[Anonymous]

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

[collinq · Accepted 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