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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
cmckernan93
Frequent Visitor

Help updating a report automatically

how do i make my power BI report and visuals update automatically rather than creating a new report every week/month and copying over the data?

 

I am using an excel docuemnt as a base for the report and keeping the format the same in regard to heading columns etc each week

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@cmckernan93 as per my understanding from your previous reply you want to know how to update power bi automatically with same figures...When you are  working with excel you can upload the excel either in Sharepoint or in Onedrive which will enable to schedule refresh in power bi service without gateway

 


Appreciate your Kudos, Press the thumbs up button!!👍

Regards,

Husna

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@cmckernan93 , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.


Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

ok so i have made a power bi report, and i want to do the same report every week and have than just have the same figures and visuals showing off the data in the excel spread sheets i have used, i want to update this visuals based on the new data i have input into the excel sheet in the meanwhile since in the excel report. Is this possible?lop.jpg

Anonymous
Not applicable

@cmckernan93 as per my understanding from your previous reply you want to know how to update power bi automatically with same figures...When you are  working with excel you can upload the excel either in Sharepoint or in Onedrive which will enable to schedule refresh in power bi service without gateway

 


Appreciate your Kudos, Press the thumbs up button!!👍

Regards,

Husna

Thanks, never though of doing that. 

Anonymous
Not applicable

@cmckernan93  you wil have to make sure not to change the excel file name and the column names rest power bi will take care:-)

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors