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.
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
Important: select authentication method Basic for Gateway connection
You can find more detailed information on setting up scheduled refresh here: