Forum Discussion
SQL Server Import data source - scheduled refresh greyed out
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
Hi AmritaOS ,
As mentioned in https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/ 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
8 Replies
Hi AmritaOS ,
As mentioned in https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/ 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
Hi, i have put in the credentials in the data source setting in my desktop file. republished. still no luck.
