Add data source to multiple datasets via rest api

h4tt3n — Thu, 26 Sep 2024 08:16:01 GMT

I am managing well over a hundred PowerBI reports and need to add a data source to all the corresponding datasets. The new data source is an azure sql db with basic auth. I have attempted to do this via the power bi rest api in several different ways, unsuccessfully.

According to the documentation, there doesn't seem to be an endpoint for simply adding / posting new data sources.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets

I have tried the PS scripts linked to in the documentation:
https://github.com/microsoft/PowerBI-Developer-Samples/blob/master/PowerShell%20Scripts/CreateDatasource.ps1

Please explain which api endpoint is the right one to use.

Cheers, Mike

Re: Add data source to multiple datasets via rest api

lbendlin — Thu, 26 Sep 2024 12:14:15 GMT

That script is for gateway data sources, not semantic model data sources.

Usually I would have said "use an app template" but in your situation that won't help.

Generally, Power Query is allergic to the idea of dynamically adding data sources. Your only option at the moment is to do this manually. Thankfully you can copy/paste queries across Power Query editors.

topic Add data source to multiple datasets via rest api in Developer

Add data source to multiple datasets via rest api

Re: Add data source to multiple datasets via rest api