Forum Discussion
Dataflow ID's - How to fetch dataflow Id's using dataflow names ( sync test and prod dataflows)
- 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
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 existing entities & new entities). In order to sync test and prod dataflow, I have deleted the previous prod dataflow and exported the test dataflow as JSON file and imported JSON file as new prod dataflow (renamed to original name as it was eariler). I have noticied dataflow id got changed and my old report is not working as dataflow id got changed.
1) Is there any way to sync test and prod dataflow without changing the dataflow id's after making changes/updates in test dataflows. So that, we don't need to update the reports/datasets which reference the data flow id's.
or
2) Is there any way to call dataflow id's by logical name in reports editor
For example: Dataflows
| Dataflows | ID's |
| 123 test | qqqq-de1a-000-tyyyy-xxxxxx |
| 123 prod | 00000-de1a-000-tyyyy-pppppp |
Report editor:
current code
let
Source = PowerBI.Dataflows(null),
#"00-000-0000" = #"00-00-0000"{[dataflowId="00000-de1a-000-tyyyy-pppppp"]}[Data],
in
Expected output
let
Source = PowerBI.Dataflows(null),
#"00-000-0000" = #"00-00-0000"{[dataflowId= "function or parameter to call "123 prod" dataflow id dynamically "]}[Data],
in
Regards,
Vijay