Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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-deskt...
https://www.youtube.com/watch?v=kEhUGUWQoGw
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |