Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I need help setting up secure external access for Power BI Desktop to connect to a SQL Server database hosted on AWS. Here’s the current setup:
1. I connect to a VPN to join my company's network from home.
2. I access a (77 box) within the company network.
3. From there, I connect to another jump server (90 box).
4. Inside the 90 box, there are two more servers:
- **27 box**: Hosts Power BI Desktop and Power BI Data Gateway.
- **92 box**: Hosts the SQL Server database (private network on AWS).
5. I use Power BI Desktop on the 27 box to connect to the SQL Server database on the 92 box using the import method.
6. I publish the reports to Power BI Service and set up a scheduled refresh.
Objective:
Configure a setup that allows secure access to the SQL Server database (92 box) from outside the company network using the internet, without relying on the current internal VPN setup.
Specific Questions:
1. What AWS configurations are needed to securely expose the SQL Server database for external access?
2. How should I configure the Power BI Data Gateway to securely connect from Power BI Service to the SQL Server database hosted on AWS?
3. What are the best practices for ensuring security and efficiency in this new setup?
Thanks in advance for your help!
Solved! Go to Solution.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
60 | |
43 | |
40 |