Create Metadata Table for Table Name, Source Item and Dataset Name

Hi PowerSchmiede ,

I tried to fix your issue with Power Query, but did not get very far. This is all the meta data I could get out:

So this is probably not sufficient... I did some research and came across these ones here:

Export a list of data source TABLES from a dataset - Microsoft Power BI Community

Using model's metadata to create table - Microsoft Power BI Community

They suggest to go via DAX studio where you should get some more stuff. However, it seems like you still would need to manually export the information into a txt file and take it from there. So not fully automated either. 

Then I thought - since you wanna save the information into sharepoint - you might wanna shoot some APIs to PBI to fetch what you need. These ones here should get you pretty far, I hope:

Datasets - Get Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Push Datasets - Datasets GetTables - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Note, here you need quite some permissions, to be able to retrieve those information. 

Though maybe not exactly what you expected, I still hope this helps a bit! 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/