Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
michaelshparber
Advocate V
Advocate V

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

1 ACCEPTED SOLUTION

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
v-gizhi-msft
Community Support
Community Support

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

GilbertQ
Super User
Super User

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

@GilbertQ 

Any reference on how to install the Gateway on EC2?

I've looked in the documentation - and no mention of AWS...

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.