Forum Discussion
How can I securely connect Power BI Desktop to a SQL Server database in a private network via a Powe
Thanks for the reply from Greg_Deckler please allow me to provide another insight:
Hi,manoj_0911Regarding the issue you raised, my solution is as follows:
Regarding your first question, the gateway configuration:
1.First, there can only be one gateway per report, even if there are multiple data sources, they need to go through the same gateway. If your dashboard is based on multiple reports, you can use a dedicated gateway for each report to distribute the load.
2.Second, you can choose DirectQuery or Import, depending on the data source. Try to separate the DirectQuery data source from the scheduled refresh data source to avoid the gateway processing a large number of requests at the same time.
3.Finally, you can keep the gateway, data source, and Power BI tenant as close together as possible to reduce network latency and improve query performance.
Here are the relevant documents:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn
Power BI implementation planning: Data gateways - Power BI | Microsoft Learn
On your second question:
1.First, we recommend that you install the Microsoft on-premises data gateway on an Amazon EC2 instance in a private subnet that contains the data source. The subnet should be configured to route requests to the internet through an Amazon VPC NAT gateway in a public subnet.
2.Second, if high availability is required, gateways on multiple EC2 instances can be installed in multiple AWS Availability Zones to form a gateway cluster.
Here are links to the relevant documentation:
On your third question:
1.First, you can take advantage of row-level security.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
2.Second, you can use sensitivity labels.
How to apply sensitivity labels in Power BI - Power BI | Microsoft Learn3.Finally, update your gateway software regularly to take advantage of the latest security enhancements.
Ensuring Data Security with Power BI: Tips and Tricks (datalogz.io)
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I received the above reply from ChatGPT, but I'm looking for input's from experienced people who have dealt with this situation. Please share your valuable insights.
manoj_0911 Well, first of all, you don't connect Power BI Desktop to a data source using a gateway. You connect from Power BI Desktop directly to the data source. The gateway is there only for the Power BI Service to be able to access on-premises data. So, your premise, I think, is not correct or I am not understanding what you are saying.
You are right, Sorry for the confusion. I need to edit my question properly.
Thanks for the reply from Greg_Deckler please allow me to provide another insight:
Hi,manoj_0911Regarding the issue you raised, my solution is as follows:
Regarding your first question, the gateway configuration:
1.First, there can only be one gateway per report, even if there are multiple data sources, they need to go through the same gateway. If your dashboard is based on multiple reports, you can use a dedicated gateway for each report to distribute the load.
2.Second, you can choose DirectQuery or Import, depending on the data source. Try to separate the DirectQuery data source from the scheduled refresh data source to avoid the gateway processing a large number of requests at the same time.
3.Finally, you can keep the gateway, data source, and Power BI tenant as close together as possible to reduce network latency and improve query performance.
Here are the relevant documents:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn
Power BI implementation planning: Data gateways - Power BI | Microsoft Learn
On your second question:
1.First, we recommend that you install the Microsoft on-premises data gateway on an Amazon EC2 instance in a private subnet that contains the data source. The subnet should be configured to route requests to the internet through an Amazon VPC NAT gateway in a public subnet.
2.Second, if high availability is required, gateways on multiple EC2 instances can be installed in multiple AWS Availability Zones to form a gateway cluster.
Here are links to the relevant documentation:
On your third question:
1.First, you can take advantage of row-level security.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
2.Second, you can use sensitivity labels.
How to apply sensitivity labels in Power BI - Power BI | Microsoft Learn3.Finally, update your gateway software regularly to take advantage of the latest security enhancements.
Ensuring Data Security with Power BI: Tips and Tricks (datalogz.io)
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.