topic Re: Extract all data source information from Power BI dataset in Developer

Extract all data source information from Power BI dataset

Anonymous — Wed, 18 Dec 2019 21:33:36 GMT

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

Re: Extract all data source information from Power BI dataset

Jayendran — Thu, 26 Dec 2019 09:39:18 GMT

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.

Re: Extract all data source information from Power BI dataset

Anonymous — Fri, 03 Jan 2020 02:03:20 GMT

Hi Jayendran,

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

Regards,

Joe

Re: Extract all data source information from Power BI dataset

Jayendran — Fri, 03 Jan 2020 06:45:44 GMT

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. )

Re: Extract all data source information from Power BI dataset

Anonymous — Wed, 08 Jan 2020 15:56:26 GMT

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

Re: Extract all data source information from Power BI dataset

Anonymous — Mon, 22 Nov 2021 20:40:25 GMT

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

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