Forum Discussion
SQL Server Import data source - scheduled refresh greyed out
- 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
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.
- AmritaOS5 years agoHelper I
Hi, i have put in the credentials in the data source setting in my desktop file. republished. still no luck.
- _sfrost5 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
- AmritaOS5 years agoHelper I
hi,
the data source credentials are also greyed out