Forum Discussion
Solved
Replace Datasources in Excel
Hello, we have many Excelsheets using different Datasource especially SQL Databases and Qubes. We'd like to replace this connections in Excelsheets with Powerbi Workspaces Contents (Dataset, Report...
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.
vojtechsima
Super User
Super UserHi, 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