Forum Discussion
Solved
Best practices for re-using reports based on dataflows
I have created a dataflow that gets data from a SQL Server through the OnPrem data gateway and a Power BI report that gets all its data from the dataflow. In the dataflow I have created a variable (t...
"I haven't found a way to duplicate the dataflow either." Export the Json, then import the json for a new dataflow.
Thanks, that is a good starting point. In the exported JSON I could then also mass-update DB connections etc. What I'm struggling with is Power BI Desktop. In Power Query Editor I see that every table has a workspace GUID, a dataflow GUID and a table/entity GUID.
Is there a better way than just replacing all GUIDs in all tables? And where do I get the table GUID from?
The table GUIDs are in the JSON file, as part of the location attribute.