Debbie Edwards on 14 Dec 2020 09:05:56
we create our dev datasets against the dev dataflows. Then when ready we move the dataflows to prod and copy the dev pbix file to make it a production one.
Once done we change the dataflow to the production dataflows. At the moment you have to get the Workspace ID and the Dataflow from settings, go into the code in Power Query editor and change the IDs
There needs to be an easier and quicker way of doing this so you can quickly move information across (We arent using Premium Pipelines but that doesn't mean that we dont want to go the Dev and Prod route
- Comments (2)
RE: Make it easier to change dataflows on a dataset
Thank you for the workaround suggestion of using parameters in power query. This saved me a huge amount of time. Hopefully this will be addressed in a future product release.
RE: Make it easier to change dataflows on a dataset
We made a workaround by making the source for workspaceId and dataflowId into parameters for each query that references a dataflow. Now we just change the parameters to switch between Dev and Prod.
But I agree, it would be nice if you could just change the data source.