Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Sorry for the newbie question. I'm looking for an authoritative link in the documentation that describes how or if Report Server, running in an AWS EC2 instance (aka, a VM) can connect to an AWS RDS SQL Server database.
I'm trying to get a client who today runs Report Server in an EC2 instance and connects to an AWS EC2 instance running SQL Server to consider migrating the database to RDS. The client insists that things "do not work" in this configuration, including the ability to refresh reports in the web UI (or at least I think that's what he's describing as the limitation).
Thanks in advance for any pointers and, especially, links to the doc that may directly address this question.
It can connect to any SQL server database, provided that underlaying network connectivity is present and you have appropriate credentials. Wherever that is true or not - depends on your VM/network configuration.
Anyways it's really pointless to put it into the cloud from security prospective.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |