Forum Discussion
Connecting to a source that restricts access by IP
We're trying to connect to an AWS PostgreSQL source that is IP restricted. We have no issue getting our company IP or home office IPs on their approved list to develop in PBI Desktop, but once we share the report in Power BI service we can no longer connect to the source. How can I find what IPs need to be approved for our shared reports to work?
I found this thread that leads to a list of all Microsoft Azure IPs. There are hundreds, if not thousands, of IPs for our region split into 40+ groups/services. Can someone help narrow the relavent services so we have a manageable number of IPs to add to the data provider's approved IP list? Do I even have my ladder against the right wall with this list of Microsoft IPs?
Those IPs are in a JSON format and meant to be scripted into your network hardware. They can change, so it isn't meant to be loaded manually. They publish updates periodically, perhaps even monthly as new data centers and other hardeware are retired or come on line.
If you just need those for the Power BI service, they start on line 24,749 this month, but search for PowerBI in that file as the row number would change each release.
2 Replies
- edhans
Community Champion
Those IPs are in a JSON format and meant to be scripted into your network hardware. They can change, so it isn't meant to be loaded manually. They publish updates periodically, perhaps even monthly as new data centers and other hardeware are retired or come on line.
If you just need those for the Power BI service, they start on line 24,749 this month, but search for PowerBI in that file as the row number would change each release.
🤦🏻♂️ I was so focused on the region part I didn't think to search the file for just PowerBI.
There's way to many IPs there to input manually. Maybe I can talk to the people managing the ADA PostgreSQL DB and suggest they always approve the IPs in this list.
Thanks, edhans
