Forum Discussion
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 and name,..) used by a Power BI dataset/report?
Please kindly assist.
Regards,
Joe
5 Replies
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
Invoke-PowerBIRestMethod -Url 'groups/{groupId}/datasets/{datasetId}/datasources' -Method GetNote that this can only gives the datasources like server,database,url and not schema name,columns name which you posted originally.
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}/tablesNote: 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. )
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
