how can i automate a dataset to refresh on the daily in power Bi

[Anonymous]

how can i automate a datset in power bi to refresh on the daily

[edhans · Accepted solution]

You just go to the Scheduled Refresh settings and enable it to refresh daily.

If Scheduled Refresh is disabled (grayed out) it is because the service doesn't know how to access your data. If it is all cloud data, the Datasource Credentials section just needs to be filled in.

If it is on prem data (SQL Server, Oracle, etc) then you must install a Gateway internally so the service can connect to the Gateway, and the gateway to your on-prem data. Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

[Anonymous]

@edhans schedule refresh is grayed out so is the data source credential. the dataset information comes from SQL server which power Bi pulls from. so i would have to install a gateway internally that connect to the SQL server?

[edhans]

Yes. That is what the gateway is for. There is no way for the web service to connect to your on-prem SQL Server without a gateway in between.

[Anonymous]

thank you @edhans