Forum Discussion
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
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
8 Replies
Anonymous , refer if this list can help
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-whitelist-urls
Hi, did you manage to find out which IP address the Data Gateway is using? I'm in the same situation right now 🙂
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:
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.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
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.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
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
