Forum Discussion

_MoZZa's avatar
_MoZZa
Brass Contributor
Jun 26, 2025

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...
accessibility
community
DavyA1980's avatar
DavyA1980
MCT
Jul 01, 2025

The on-prem LAN's etc shouldn't be required anyways if it's just PBI. Based on your replies you've already tried several paths. Probably already tried to use SAS as well? SAS should bypass network restrictions. I'll probably have time to test something tomorrow. I'll get back to you after some testing.

Direct access to an Azure Storage account with the firewall enabled and in the same region as Power Query Online isn't supported. This limitation arises because Power Query services, when deployed in the same region as the Azure storage account, use private Azure IP addresses for communication. 

  • _MoZZa's avatar
    _MoZZa
    Brass Contributor
    Jul 03, 2025

    Hi DavyA1980​ ,
    I tried the SAS approach, connection to Power BI Desktop via SAS worked fine, as it uses web connections i think.
    However, SAS would not authenticate and connect to enable auto refreshes etc., via Data Source Credentials in the Semantic model. Not sure why it didn't work, same connection error.

    Is there a way to determine the private IP address where PBI will be coming from?
    If there is I could put that as the source IP in the VNet rules. 🤷

Resources