Forum Discussion
Storage Accounts - Networking
Hi All, Seems like a basic issue, however, I cannot seem to resolve the issue. In a nutshell, a number of storage accounts (and other resources) were created with the Public Network Access set a...
You may consider below:
- Use an On-Premises Data Gateway
- This is the most reliable workaround.
- Install the gateway on a VM (on-prem or in Azure) that has access to the storage account.
- Power BI Service connects through the gateway, which acts as a Proxy.
- This avoids the need to open your storage account to the public Internet.
- Use a Private Endpoint + DNS Configuration
- The DNS resolution for the storage account points to the private endpoint.
- Power BI is accessing the storage via a VNet that has access to the private endpoint.
- If Power BI is outside the VNet, this won’t help unless you route traffic through a gateway or ExpressRoute.
- Add Power BI IP Ranges Manually
- Microsoft publishes weekly JSON files with IP ranges for all services.
- You can extract the Power BI Service IPs for your region and add them to your firewall rules.
Hi Kidd_Ip,
Thank you for your reply.
I had 'partially' implemented option 3, I say partially as I may have sourced the deprecated IP list from an older file. But I have downloaded the latest offering and applied all the PowerBI.UKSouth IP's and even added the PowerBI.UKWest IP ranges too. And still no joy.
I am going to implement option 1 and see how that goes.
I will definitely feedback with the outcome.👍
