Extract specific datasources on powerbi

[noobie12]

Would it be possible to extract datasources from the artifacts present to my capacity? For example, Dataset A has snowflake as a datasource and i would like to check what's the corresponding table is related to the query. I have tried the API for it but it is only restricted to snowflake and no database/table is mentioned.

Appreciate your ideas on this.

[rubayatyasmin]

Hi, @noobie12 

Try lineage view in power bi service. 

refer: Data lineage - Power BI | Microsoft Learn

similar thread: Extract all data source information from Power BI ... - Microsoft Fabric Community

[noobie12]

Hi @rubayatyasmin,

lineage view will not work since it does not mention any specific tablenames or view to the source such as snowflake. 

since the post you gave was 2019, do we have a updated API call or technique wherein we can only check the datasources like schema name, columns name mention on the datasource.

[rubayatyasmin]

Hey @noobie12 

did you try to use get datasources API in PBI? If not, give it a shot. 

refer: Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[noobie12]

Hi @rubayatyasmin , 

thank you for your reply. upon checking, it is only giving high level information. i am trying to get the sources being used in the pbix file without opening the pbix file one by one. for example, my pbix has sap bw server as a source and i would like to know which database/tables it connects to without opening pbix file. 

[rubayatyasmin]

sorry then I do not know how to help you. If you know then let us know here. 

thanks