Forum Discussion
Automate Dataflow export to .json through Power Automate or Azure Logic Apps
You need to replace in the URL https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}
{groupId}: This is the workspaceId where you have the dataflow
{dataflowId} This is the dataflowId
If you open the dataflow in PowerBI Service the URL reads something like this:
https://app.powerbi.com/groups/xx9xx9x9-x9x9-x9x9-x9x9-xx9xx9x9x9x9/dataflows/xx9xx9x9-x9x9-x9x9-x9x9-xx9xx9x9x9x9?experience=power-bi
GroupId in the Basic URL is the ID between groups/ and /dataflows/
DataflowId in the Basic URL is the ID between /dataflows/ and ?experience
You will need to authenticate using your user/pasword (same credentials as you use to log in to Power BI).
The only other thing to check that I can think of is that you have the Tenant Setting to run REST API calls enabled which I believe is in Integration Settings (but not 100% sure) Integration admin settings - Microsoft Fabric | Microsoft Learn
Hope this helps.
This is not what I am asking. I would like to export a Power BI Dataflow from the Power BI Server automatically through a Power Automate or Azure Logic App (preferred tool). Right now you can only go to your workspace find your dataflow and right click and select "Export .json". Is there a way I can use an Azure Logic App to export all my dataflow on a scheduled basis? Thanks.
Did you manage to find a solution for this, I am also looking for a way to do this so there always is a recent .json stored away as a fallback
Sadly, I have not found a solution for this. I have been just exporting the Dataflows manually and checking them into my repository.
Unfortunate, but thanks for the swift response