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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Jayendran,

Thanks the API. However I would like to extract database tables names. Can you assist?

 

Regards,

Joe

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