Unable to setup schedule refresh on SQL database?

[Anonymous]

Hi,

I've a SQL database as data source which is setup as Import and has unique database credentials. 

The Dataset is configured on PBI Desktop and everytime I refresh it works fine however when I publish it to PBI Service I loose the PBI Scheduled refresh option it gets greyed out.

Could some one please tell me if its PBI limitation or is it possible to setup a Seheduled refresh on SQL database. I've tried both direct query and Import yet both is not letting me setup a scheduled refresh

Thank you

[v-jayw-msft · Accepted solution]

Hi @Anonymous 

Do you have install and manage gateway for Power BI?

Check the documents below.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql 

Best Regards,

Jay

[amitchandak]

@Anonymous , Just check do you need on-premise gateway for that. if yes is that setup?

gateway
https://community.powerbi.com/t5/Desktop/Personal-Vs-Enterprise-Gateway/td-p/767443
https://www.desertislesql.com/wordpress1/?p=1067
https://radacad.com/the-power-bi-gateway-all-you-need-to-know