SQL Server Import data source - scheduled refresh greyed out

[AmritaOS]

Hello,

i am wonderinf if i coudl get some help on this please - 

Data source - SQL server import mode - i am executing a stored procedure. (database on AWS)

when i publish the rfeport to the service i am unable to schedule a refresh or update the data set credentials as they are greyed out. 

the error i am getting is - 

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

i am able to refresh the dataset in the desktop.

is there something i can do to have scheduled refreshes without installing a gateway?

thanks,
Amrita

#SQLRefresh

[v-deddai1-msft · Accepted solution]

Hi @AmritaOS ,

As mentioned in https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analy...you need to install a on-premise gateway.

Networking infrastructure that includes VPC, public and private subnets, security groups, internet gateway, NAT Gateway, and route tables

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[_sfrost]

@AmritaOS 

You may need to have a look at the Data Source Credentials in dataset settings. If it allows you to enter the credentials, then you would not need a gateway.

[AmritaOS]

Hi, i have put in the credentials in the data source setting in my desktop file. republished. still no luck.

[_sfrost]

@AmritaOS 

Entering credentials only in Desktop will not work. After publishing, you should enter the credentials again in Power BI Service.

Expand Data source credentials > select the source > update credentials. 

Please refer to the below screenshot

[AmritaOS]

hi, 

the data source credentials are also greyed out

[_sfrost]

In that case, you require a gateway

[AmritaOS]

thanks for your help.

[_sfrost]

Let me know if you have any further queries or If I have answered your concerns, mark answer as solution.