Extract all data source information from Power BI dataset

[Anonymous]

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 and name,..) used by a Power BI dataset/report?

Please kindly assist.

Regards,

Joe 

[Anonymous]

Were you able to extract the tables themselves using the API?

I wish to leverage PowerBI queries for a website I'm building. 

[Anonymous]

Hi Jayendran,

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

Regards,

Joe

[Jayendran]

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]

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

[Jayendran]

Hi @Anonymous ,

Yes there is a PowerShell (internally calls the PowerBI REST API Datasets - Get Datasources)

REST API : https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup

PowerShell: https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.profile/invoke-powerbirestmethod?view=powerbi-ps

Invoke-PowerBIRestMethod -Url 'groups/{groupId}/datasets/{datasetId}/datasources' -Method Get

Note that this can only gives the datasources like server,database,url and not schema name,columns name which you posted originally.