The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
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
@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.
Raise it as an idea.
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
So, there is no way to do this today?