How to configure Schedule Refresh in Power BI Service?

Understanding data refresh
Whenever you refresh data, Power BI must query the underlying data sources, possibly load the source data into a dataset, and then update any visualizations in your reports or dashboards that rely on the updated dataset. Power BI enables you to go from data to insight to action quickly, yet you must make sure the data in your Power BI reports and dashboards is recent. Knowing how to refresh the data is often critical in delivering accurate results.

You can find more detailed information on setting up scheduled refresh here:

To configure Scheduled refresh, you need to:
1. Export connector to Power BI Desktop
2. Click on Publish and save file (.pbix) format

3. Select My workspace and click on the link

4. Go to Power BI Service https://app.powerbi.com/
5. Click on My workspace--> Datasets-->Schedule refresh

6. Click Gateway connection and Install personal gateway

7. Click Data source credentials
Important: select authentication method Basic for Gateway connection

8. Click Scheduled refresh
The Scheduled refresh section is where you define the frequency and time slots to refresh the dataset. Some data sources do not require a gateway to be configurable for refresh; other data sources require a gateway.

Set the Keep your data up to date slider to On to configure the settings.