Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help connecting Power BI with Azure Table through Azure Storage Account firewall

Hello,

I am trying to allow Power BI to use Azure Table without using data gateway. This works if I open the storage account to the world, by going to storage account -> Firewalls and virtual networks -> All networks -> allowed. With this setting I can schedule refresh using the storage account access keys for authentication. However, by the policy in our company we can only allow selected networks.

I have looked at other posts, such as this: https://community.powerbi.com/t5/Service/Need-clarity-around-how-to-connect-to-Azure-Storage-through-a/td-p/969674, and as per recommendation I added the IP ranges for the servicebus.NorthEurope to my firewall (North Europe is where my Power BI data is stored), and also all the following IP ranges for testing:
13.64.0.0/11, 20.0.0.0/8, 23.0.0.0/8, 40.0.0.0/8, 51.0.0.0/8, 52.0.0.0/8, 65.52.0.0/16, 94.245.104.64/28, 102.133.0.0/16, 104.0.0.0/8, 111.221.95.24/29, 137.0.0.0/8, 138.0.0.0/8, 157.56.13.112/29, 168.0.0.0/8, 191.0.0.0/8, 207.46.0.0/16,

and then I also tried these ones:
13.0.0.0/8, 20.0.0.0/8, 23.0.0.0/8, 40.0.0.0/8, 52.0.0.0/8, 51.0.0.0/8, 64.0.0.0/4, 80.0.0.0/4, 96.0.0.0/4, 112.0.0.0/4, 128.0.0.0/4, 144.0.0.0/4, 160.0.0.0/5, 168.0.0.0/6, 176.0.0.0/4, 207.0.0.0/8. But every configuration returns the same error of invalid credentials.


A pointer to the correct service tag and IP ranges would be very helpful.

Thanks, Dawid

Need Help

4 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    I know the address prefixes for North Europe like below. But I'm not familar with this whole process. If this can't work for you, please create a support ticket to get the dedicated support.

     

    {
      "name": "ServiceBus.NorthEurope",
      "id": "ServiceBus.NorthEurope",
      "properties": {
        "changeNumber": 1,
        "region": "northeurope",
        "platform": "Azure",
        "systemService": "AzureServiceBus",
        "addressPrefixes": [
          "13.69.227.64/29",
          "13.74.107.64/29",
          "13.74.142.88/32",
          "52.138.226.64/29",
          "191.235.170.182/32"
        ]
      }
    }

     

    How to create a support ticket in Power BI  

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Xue Ding,

      Thanks for your reply, unfortunately this does not work. I will be opening a support ticket and will update here if I manage to find a solution to this.

      Regards
      Dawid

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Have you resolved it now?  Can you please share your solution? There are not many topics about this. More people will benefit from this thread. Thanks in advance.😉