Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
The IP they are looking for is a gateway IP address that will be attempting to connect not SQL IP
@Anonymous , refer if this list can help
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-whitelist-urls
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |