Forum Discussion
Helper VAdding new sheet to existing excel file
Dear Experts
I created a Power BI presentation using a excel file that contain many sheets inside. (All sheets are of the same format)
Every month I will add in a new sheet but when I refresh Power BI the new month's data will not appear inside my query.
Is there a better way to do this then to create a new report every month?
If yes please help me why showing me the steps to do it!
Thank you in advance and let me know if my explanation is not clear enough =D
Yuiitsu -
- Put each sheet into it's own Excel file and put all of these excel files into a single folder
- Open a new Power BI file
- Home tab, Get data | More | Folder
- Point to your folder with all of the Excel files
- Do any manipulation you need to do and then load the data
- Ensure that the data is exactly as in your current report
At this point, you can copy and paste visuals between your old report and your new report. Alternatively, make a copy of your existing report. Open it. In the new report with the Folder query, go into Query Editor, Advanced Editor copy the code. Go into the copy of your old report, Query Editor, find your query, Advanced Editor, Select All, paste in the code.
5 Replies
- Greg_Deckler
Community Champion
Yes, publish each Excel file as a new file with the same sheet. Use a Folder query to ingest all of the Excel files and append them together.
YuiitsuGreg_Deckler Forgive me if I misunderstood your message.
Does this mean I do not have to redo the entire report again?
If not do you mind if you can further explain "Use a Folder query to ingest all of the Excel files and append them together." this step?
I am new to Power BI and still not familier with alot of terms and usage.
Thank you!
- amitchandak
Super User
