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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
86010991
Frequent Visitor

Need Help adding Historical Data from Excel into Power BI tables

 

Hello,

 

I have a report in Power BI that is automatically updating data daily and I'm taking snapshots once a week for historical purposes going forward.  I need to upload 12 months of historical data from Excel based on monthly extraction dates to build a trended sales report visualization chart...


The daily data is contained in two tables currently - Historical Forecast Appended and Historical Opportunities Appended...both of which I am taking weekly snapshots in an Access database to generate weekly extraction dates for reporting purposes.

 

The Excel historical data is contained in one single table, but the columns in that Excel table are split up into the Historical Forecast Appended and Historical Opportunities Appended tables.  

 

What is the best method for manually adding the necessary historical data into the existing tables in Power BI? 

Example of chart from Excel pivot table trying to recreate in Power BI:

86010991_0-1616175351848.png

 

Thanks in advance! 

 

 

 

1 REPLY 1
amitchandak
Super User
Super User

@86010991 , Is importing the file in power bi and append with the existing table is not an option that is working for you.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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