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
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
5 years agoHelper I
hi,
the data source credentials are also greyed out