Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Extract all data source information from Power BI dataset

Hello, is there a way using Powershell Power BI API to extract data source artifacts (i.e database server name, database name, database schema name, database tables, columns names, flat file path an...
Need Help
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi Anonymous ,

 

There is a seperate API which can gives you the tables Push Datasets - Datasets GetTablesInGroup

 

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables

 

Note: This API supports only Push datasets (in other words meaning you can only use this API against the datasets created via REST API. A normal dataset published from PBI desktop doesn't support this. )

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Jayendran

Our datasets are created from Power BI Desktop, so that API cannot provide me with what I want. Also it extracts Power BI tables, not database tables.

 

Regards,

Joe