IP address data gateway

[Anonymous]

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

[v-henryk-mstf]

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]

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

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

For this type of error, try to enable https mode in the gateway's network and restart the gateway does it work?

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

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

[v-henryk-mstf]

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]

Hi

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

[amitchandak]

@Anonymous , refer if this list can help

https://docs.microsoft.com/en-us/power-bi/admin/power-bi-whitelist-urls

[Anonymous]

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