Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Yuiitsu
Helper V
Helper V

Adding 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

 

1 ACCEPTED SOLUTION

@Yuiitsu - 

 

  1. Put each sheet into it's own Excel file and put all of these excel files into a single folder
  2. Open a new Power BI file
  3. Home tab, Get data | More | Folder
  4. Point to your folder with all of the Excel files
  5. Do any manipulation you need to do and then load the data
  6. 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.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

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.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_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!

 

@Yuiitsu - 

 

  1. Put each sheet into it's own Excel file and put all of these excel files into a single folder
  2. Open a new Power BI file
  3. Home tab, Get data | More | Folder
  4. Point to your folder with all of the Excel files
  5. Do any manipulation you need to do and then load the data
  6. 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.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I have figured it out actually...

 

The new sheet has to be added at the back of the excel sheet and not the front.

Problem solved! Thanks for all the additional info!

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.