This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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/CreateDataso...
Please explain which api endpoint is the right one to use.
Cheers, Mike
Solved! Go to Solution.
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.
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.