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 ,

 

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.