topic Re: I'm unable to setup Datarefresh as both Data Source credentials and Scheduled refresh is grayed out in Report Server

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

Anonymous — Fri, 17 Apr 2020 17:28:58 GMT

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

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

Greg_Deckler — Fri, 17 Apr 2020 19:03:07 GMT

You need to have a gateway installed and online.

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

Anonymous — Sat, 18 Apr 2020 10:38:32 GMT

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?

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

Greg_Deckler — Sat, 18 Apr 2020 16:06:43 GMT

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

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

Anonymous — Wed, 22 Apr 2020 18:58:36 GMT

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. 🙂

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

Greg_Deckler — Wed, 22 Apr 2020 21:15:40 GMT

Sweet! That's always best case!