Forum Discussion
AmritaOS
5 years agoHelper I
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 servi...
- 5 years ago
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
_sfrost
5 years agoSolution Specialist
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
5 years agoHelper I
Hi, i have put in the credentials in the data source setting in my desktop file. republished. still no luck.