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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
botjeff
Regular Visitor

How do I do automatic data refresh ?

Hi ,

I have a dashboard that is built using two excel files. Those 2 files are daily updated and uploaded in our company's shared files. How do I schedule refresh every day so that the numbers in PowerBI is updated on daily basis ?

When I build the dashboard, I simply upload the two Excel files and start building. Might've been a mistake, for not establishing a connection first. Wish someone can lay down some options for me, and the tutorials. Thank you

4 REPLIES 4
Raghava_1998
Regular Visitor

Hi botjeff,
You can do schedule refresh in powerbi service.
Link: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

lbendlin
Super User
Super User

When you say "shared files"  do you mean a SharePoint Document Library?

Sorry, i meant like just company's server folder. It's not exactly on the web like Sharepoint, more like on premise database.

That requires a gateway.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors