Forum Discussion
Replace Datasources in Excel
upfaffer
I suppose, if you have the data loaded through Power Query in Excel, you can just copy the Queries or their Code from Advanced Editor and paste it into the new Dataflow's power query window and all steps will be done in the dataflow, given the Dataflow and its Gateway can see on that file.
upfaffer
I suppose, if you have the data loaded through Power Query in Excel, you can just copy the Queries or their Code from Advanced Editor and paste it into the new Dataflow's power query window and all steps will be done in the dataflow, given the Dataflow and its Gateway can see on that file.
Could you share more details or perhaps a howto description from the internet?
Hi, upfaffer
something like this:
Here is how to do it from Excel:
https://docs.microsoft.com/en-us/power-query/dataflows/how-to-migrate-queries-from-power-query-desktop-to-dataflows
https://www.youtube.com/watch?v=kEhUGUWQoGw