Forum Discussion
Dali748
Helper II
Helper IIConnected to SQL database, can't setup scheduled refreshes (greyed out)?
I created a report in "Desktop" that connects to a SQL database table, I then published this to "Service" and when I try to setup a "Scheduled Refresh" I noticed it's all greyed out. Also, the "Data...
GilbertQ
Super User
Super UserHi there
In order to refresh On-Premise data, as in your example SQL Server, you will need to install and configure the On-Premise Data Gateway.
Here are details on how to get this done:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
And to configure SQL Server:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
In order to refresh On-Premise data, as in your example SQL Server, you will need to install and configure the On-Premise Data Gateway.
Here are details on how to get this done:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
And to configure SQL Server:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial