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.
Hi, upfaffer
Create a Dataflow in your workspace, put all your data there and then use this dataflow as the source for your reports.
The question is just how to replace the data mapping in Excel? Your answer do not fits this request
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