The auto refresh function is greyed out and I dont know how to enable it

[Jen_Hynds]

Hi

im a fairly new user, i have prepared a report and published it, i have tried to set an auto refresh, but its greyed out.  i have to manually refresh and republish the report to get it to update. it is stored on my work one drive and i am publishing to the workspace, teams and sharepoint

help!

[v-eachen-msft · Accepted solution]

Hi @Jen_Hynds ,

If you used an on-promises data source, you need configure it in the gateway.

If you used a cloud data source, you need set correct credential.

Here are the documents for your reference:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/refresh-data

[Jen_Hynds]

thank you , really helpful, i will investigate

[Aron_Moore]

There's a couple of settings you should check; gateway and credentials,