Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Is there a way to automate the setting of dataflow datasource via PowerBI REST API or Powershell?

Below is the settings dialog for a dataflow.

I was wondering, if there is a way by which I can set this in an automated way by using PowerShell or the REST API for powerBi service.

 

rajraoncm_0-1597702119647.png

 

It feels like the steps one would have to do is to first bind the dataflow to the gateway and then map the datasource. But, I cant seem to find a bind method for dataflows, although one exists for datasets (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/bindtogatewayingroup#example-with-dataso...). And I am not sure what the 2nd call would be, even for a dataset.

 

TIA

4 REPLIES 4
KevinSnow
Frequent Visitor

@Anonymous Did you ever find a solution to this problem?  I just bumped up against the same thing and it's preventing us from being able to automate our deployments as well.  

lbendlin
Super User
Super User

Raise it as an idea.

Anonymous
Not applicable

Vote for the idea of full parity between Datasets and Dataflows. The goal being, one should be able to fully automate the deployment of dataflows using scripts via the REST API: https://ideas.powerbi.com/ideas/idea/?ideaid=a73db13e-17e1-ea11-bf21-281878bd6a00

Anonymous
Not applicable

So, there is no way to do this today?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors