Forum Discussion
I'm unable to setup Datarefresh as both Data Source credentials and Scheduled refresh is grayed out
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
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
5 Replies
- Greg_DecklerCommunity Champion
You need to have a gateway installed and online.
- AnonymousNot applicable
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_DecklerCommunity Champion
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