I'm unable to setup Datarefresh as both Data Source credentials and Scheduled refresh is grayed out

[Anonymous]

If I install a personal gateway, I'm able to configure and successfully refresh the data.

But If I'm trying to use the default free data refresh available in Powerbi - I don't see the options are enabled. 

Both Data Source Credentials and Schedule Refresh is grayed out? I'm going circles to fix this. please help

@amitchandak 

[Greg_Deckler]

You need to have a gateway installed and online.

[Anonymous]

@Greg_Deckler - Thank you.  I remember when I first tested with powerbi dashboard, was able to set data refresh automatically for test script and at that time, there wasn't any Gateway.

So, Are you saying there is 0% chance for anybody to have Data refresh to be scheduled without gateway?

[Greg_Deckler · Accepted solution]

Depends on the data sources in the report. Some data sources require user gateways, others do not. (Note, they ALL require gateways but sometimes you are using the default gateways setup in the Service and you do not need a separate gateway installed by you or within your organization).

Although, I will say that certain things that didn't use to require a gateway now do, like Azure SQL Database for example. And I do not know if that is an intentional change or is some kind of bug going on in the Service. 

Check out the issues forum, I am sure there are some of these listed. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

Thanks @Greg_Deckler . Thanks for inputs. I changed some of the files from local drive to sharepoint location and thus, I had all files online and none them in the Hard drive. So, Powerbi gave a notification that gateway is not required in this case. 🙂 

[Greg_Deckler]

Sweet! That's always best case!