Forum Discussion
Securing the connection between Power BI and Azure SQL Database
Hello Eric! Nice to meet you.
We have tested this solution but it's only applied to VM's which have installed PowerBI in Azure and this escenario runs right. Unless, we're testing another solution and with more control, is accessing from on-premise network to consume Azure SQL PaaS through ExpressRoute connection. We have thought an intermediate infrastructure (like proxysocks) to redirect the traffic and centralized the configuration between private IP vnets to public gateway of Azure SQL PaaS, but there is a problem with the configuration in the endpoint clients because it should be applied for each application. Have you have tested one solution to consume Azure SQL through ExpressRoute?
Thank you very much in advance.
Best regards, Rafael.
Hello! Thanks for your question.
I'm a community manager here, but I'm not a product expert and I'm sharing this on behalf of the Azure team.
If you have specific questions regarding the content, I'd recommend responding directly to the blog here as a comment: https://azure.microsoft.com/en-us/blog/securing-the-connection-between-power-bi-and-azure-sql-database/
Other community members should feel free to chime in here though!