Skip to main content
Microsoft Idea

Power BI

Needs Votes

Support integration with Azure Data Lake Gen 2 as a trusted service so firewalls can be activated

Vote (38) Share
Power BI User's profile image

Power BI User on 11 Jun 2020 08:10:43

Power BI dataflows are an excellent way to leverage the power of Azure data lake gen2. The feature for data flows to store to data lake is currently in preview, but I thought I would get this idea in as I believe it will be a blocker for many organizations.

Data lake best practice (and security center default policy) is to activate a firewall on Azure data lake Gen 2. However, if we do this, dataflows configuration event and data storage fails. We tried adding calling IPs to the firewall rules, but this is not possible as the firewall only supports public IPs. Also, managing these will be poor solution in a production environment.

Put simply - it's not possible to use data flows with Azure data lake gen 2 if the data lake has a firewall. This is a big issue for most companies, who cannot deactivate their firewall like this.

It would be great if we can add Power BI dataflows as a trusted service in the firewall configuration in Azure data lake gen2, or provide some other solution so that we can activate the firewall but allow data flows to still work.

Thanks!

Comments (2)
Power BI User's profile image Profile Picture

Hitesh Naran on 04 Apr 2024 18:07:22

RE: Support integration with Azure Data Lake Gen 2 as a trusted service so firewalls can be activated

This would help us secure.

Power BI User's profile image Profile Picture

Joanna Podubinska on 02 Jun 2023 09:08:28

RE: Support integration with Azure Data Lake Gen 2 as a trusted service so firewalls can be activated

Great idea