Forum Discussion
Add new sheets to existing excel
I have created an excel file with 2 sheets but I now need to add more sheets. These are new months with the same row headers but Power BI does not seem to see these. New to all this, is there a way to tell Power BI that there are new sheets in the excel file to pull the refresh data from?
I had seen very limited info online about this and from what I've seen it says to create a new Get Data, the problem is I have so many calculated columns and measures and to re-do all those would take a long time.
Thanks
3 Replies
Applicable88Impactful Individual
richpow , this is something you can change in PowerQuery editor. Do you want to add adtitional sheets from your Excel file or you change the amount of columns in the same sheet?
In case you add more sheets, simply right click on the left side in PowerQuery and add a new datasource again and this time just add the new sheet. A sheet is a new source in PowerQuery. If you loaded that new sheet you can combine/join with your existing sheet. In case you just renew your Calendar data, why you don't just write these rows directly into the first sheet?
Hope it helps.
Best.
PaulDBrownCommunity Champion
If the new sheets have exactly the same structure, it's probably more efficient to save each sheet as a new file and then use the option of the folder as a source.
- v-easonf-msft
Community Support
Hi, richpow
After adding sheets and modifying the model, if the model structure does not change, then there is no need to worry about the original measures and visuals being destroyed. You can copy a file for testing first.
Best Regards,
Community Support Team _ Eason
