Forum Discussion
Solved
What do I need to Connect to SQL Server hosted on AWS?
I want to publish to the service a desktop model that connects to a SQL Server hosted on AWS.
What will I need to schedule a refresh?
A Gateway on AWS? Some settings on AWS?
Will appreciate any help on this
- Hi there
The EC2 is a virtual machine?
You create a VM running Windows in AWS and then install and configure the Gateway on this VM?
4 Replies
- Hi there
What you would need to do, is to install the Gateway on an EC2 instance in AWS that can connect to the SQL Server.
Then you can use the Gateway to schedule refreshes or DirectQuery Hi,
Please try to configure the data source on Power BI Service setting->datasets.
Reference: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh#scheduled-refresh
Best Regards,
Giotto Zhi
