Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IP address data gateway

Hi

 

I have an on-premises data gateway installed on my local machine. I also have a powerbi report pulling data from a SQL Server that I have access to within our team.  I want to publish the report and schedule refreshes. The team that manages the SQL database is asking for the gateway IP address (to whitelist) so that refreshes can run successfully. Where do I find that?

 

Thank you

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi

       

      I provided the team with a list of IP addresses to whitelist but I still get an error as below when I try to create a datasource connection.

       

      When they check there can see my attempts to connect but they can't see the IP address

      • HW-Odevo's avatar
        HW-Odevo
        Frequent Visitor
        1 year ago

        Hi, did you manage to find out which IP address the Data Gateway is using? I'm in the same situation right now 🙂

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Is the path to the ip address in the screenshot below what you want?

    For more details, you can read related blog as below:

    SQL Server - Power BI Gateway problem using external IP or hostname to access database - Dirceu Resende


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi

       

      The IP they are looking for is a gateway IP address that will be attempting to connect not SQL IP

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Open the gateway, click start test test result lists all the servers, ports and IP addresses required for the gateway and opens it in the default text editor.

    For more details, you can read related document link.

    Adjust communication settings for the on-premises data gateway | Microsoft Docs

    How to configure Power BI Enterprise Gateway Proxy configuration? – Beyond the Horizon… (rajanieshkaushikk.com)


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I shared the test results IPs with the (all said successful). They whitelisted the HostIp address but still did not work.

      On the links there's a test suggested which I did but gave me this

      Not sure what Tcp : False means. The Db guys have informed me that the database sits on an AIX machine with tcp/ip communication