cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
upfaffer
Regular Visitor

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, Reports) without redesign the Excelsheets and create to much effort. What is the best way to handle this?

 

Example, we create for each SQL Database a dataset in Powerbi Workspace, with the same configuration, structure and content.
When we try to add this in addtion (How to for direct replace is not know), it shows only a insert option of Pivot not the table structure (columns). Any suggestions?

1 ACCEPTED SOLUTION

@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.

View solution in original post

5 REPLIES 5
vojtechsima
Super User
Super User

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?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors