Refreshing PowerBI from Excel on a schedule

[Anonymous]

Is there anyway that this is possible to do on a set schedule without me having to go in and do it physically?

1) Power BI refreshes all tables from the source which in this case is Excel residing on Sharepoint

2) Power BI publishes so all devices, both mobile and desktop can see the updated information

[V-pazhen-msft · Accepted solution]

@Anonymous 

The basic flow of power bi is create report in desktop=> publish to power bi service to view and share with others.

Then you can configure schedule refresh in Power bi Service, which requires gateway. Please follow the doc step by step: 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh

[Anonymous]

Publish the report. Then login into power bi (https://powerbi.microsoft.com/) find your dataset and enter the schedule within settings