Forum Discussion
Helper IChange Dataflow on an existing dataset
Hi!
I used XMLA endpoint to load millions of rows into our (incremental) dataset partitions. It took a very long time.
We need to change the dataset to point to from Dataflow A to Dataflow B (as Dataflow A no longer exists).
Is there any way, using ALM Toolkit or Tabular Editor or the XMLA endpoint to change the workspace & dataflowid?
If I republish the pbix, all the data will be overwritten and an entire day of work will be lost.
Thanks for any advice!
I found a solution!
https://data-marc.com/2020/06/25/bring-existing-tables-to-power-bi-dataflows-with-tabular-editor/
With that said, Greg_Deckler , I'm totally going to parameteritize these going forward!
3 Replies
- JoyH
I found a solution!
https://data-marc.com/2020/06/25/bring-existing-tables-to-power-bi-dataflows-with-tabular-editor/
With that said, Greg_Deckler , I'm totally going to parameteritize these going forward!
- Greg_Deckler
Community Champion
JoyH Hmm... I am not aware that either of those tools can really touch the underlying queries. The only thing I know that can edit the queries is Power Query Editor. I realize that you don't want to hear this but this is why you should make your data sources based on parameters and use deploymen pipelines and never hardcode the sources.
I will look around to see how you might go about changing this but I'm not super confident there will be a solution.
