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.
Hi,
I have used Query editor to build a data source combining multiple tabs from multiple .xlsx files from multiple folders.
There are 23 individual queries that all merge together at the end into 1 table.
Is there anyway I can export the whole thing into a Power BI report that already has charts set up for this data
I want to avoid rebuilding each query 1 by 1
Solved! Go to Solution.
Select all queries, right click, copy. I confirmed that you can then paste this into a new pbix and it works.
Did you create this in Power Query in Excel? Or are you trying to move the query from one pbix file to another?
Either way, you can always copy and paste the M code from the advanced editor for each query to recreate your data model in Power BI. You can also copy all M code at the same time and then see if you can paste it into the pbix, but I'm not sure that it will create multiple different queries or try to do it all in one.
I created it in Power BI Query.
Yes I can copy the M code from each query indivudally, however how do I get all the M code across multiple queries at once?
Select all queries, right click, copy. I confirmed that you can then paste this into a new pbix and it works.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |