Move data source from one report to another

[mbegg]

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

[dkay84_PowerBI]

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.

[mbegg]

@dkay84_PowerBI

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?

[dkay84_PowerBI · Accepted solution]

Select all queries, right click, copy.  I confirmed that you can then paste this into a new pbix and it works.

[mbegg]

@dkay84_PowerBI thanks very much, that is great!