Point copied repot/dataset to new dataflow

[Anonymous]

We have several clients all with vast amounts of data. Data for wach client is structured excatly the same and stored in different SQL databases. Each client will have their own workspace and set of reports. We are trying to copy a workspace from one to another and have the reports/datsets point to the correspondint dataflow (which contains data specific to the client). I can import the dataflow by downloading  the dataflow.json file and editing it and importing it. The new dataflow has the correct data, but any report /dataset I copy over is always "shared" and points to the original dataflow/report? How can I repoint a report/dataset to the new dataflow in the workspace.

[Dan2]

We faced a similar problem, and found nothing in the API to adjust this. So to make this work we added two parameters in the dataset. One for workspace id and the other for dataflow id. Then in the advanced editor reference these parameters instead of the actual id value. Then you can use the powerbi API to adjust the parameter values to the correct id's, or you can adjust manually if you want to go that route. If you find another way to get to get this to work, I would love to know.

[Greg_Deckler]

@Anonymous  - I believe you will need to download the PBIX and use Advanced Editor to edit the query, it should look like:

let
Source = PowerBI.Dataflows(null),
#"guid##################" = Source{[workspaceId="guid##################"]}[Data],
#"guid2##################" = #"guid##################"{[dataflowId="guid2##################"]}[Data],

You will need to replace those GUID's with the new GUID's.