Dataflow ID's - How to fetch dataflow Id's using dataflow names ( sync test and prod dataflows)

Hi All, I have created two dataflows 1) test 2) prod and created a reports using prod dataflow. it's all working fine. But, I made few changes to test dataflows (added new columns to existin...

Dataflow

Yechiel
6 years ago
Yuo can use dataflowName instead of dataflowId:

let
Source = PowerBI.Dataflows(null),
Q1 = Source{[workspaceId="4594d842-dbff-4606-a56a-e03f931fbbf5"]}[Data],
Q2 = Q1{[dataflowName="DFName"]}[Data],
Query1 = Q2{[entity="Query"]}[Data]
in
Query1