How do I do automatic data refresh ?

[botjeff]

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

[Raghava_1998]

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]

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

[botjeff]

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

[lbendlin]

That requires a gateway.