how do I whitelist all the powerBI IP addresses in success factors?

[danielru]

Hi,

I need to whitelist power bi service ips in success factors but I'm struggling to do it.

I have a json file with a list of all Microsoft's IPs from here https://www.microsoft.com/en-us/download/details.aspx?id=56519.

I normally add ip addresses under an allow list for my api user in the Password & Login Policy Settings, however the list of ips in this file is too large to fit in the text box.

How do I whitelist power bi service for my api user in success factors?

Thank you.

Daniel

[danielru]

Hi Community,

I found the answer after a long time of struggling. 

Steps:

1. Make sure your API user is set so the password does not expire as this also results in the same opaque error.

2. Check which datacentre your data is kept in see steps on how to do this here: https://learn.microsoft.com/en-us/fabric/admin/find-fabric-home-region 

 3. Get the Azure IPs as described below:

• Download the JSON file listing of IP addresses for all Microsoft services:

https://www.microsoft.com/en-us/download/details.aspx?id=56519

• Open the JSON file in VS code and search for the service (PowerBI.WestEurope) to locate the datacentre: In my case it was West Europe for PowerQueryOnline and PowerBI. search for your region based on step 2 (I added both sets of IPs PowerQueryOnline and PowerBI):

Next thing is to convert these IP addresses into manual ranges that Success Factors can understand.

You can use copilot or chatgpt to do this for you. Both the IPv4 and IPv6 are acceptable but you must convert both to manual ranges.

The ranges must be comma separated into Success Factors:

• Add all the manually converted ranges to Success Factors API users in   Password & Login Policy Settings: > Set API login exceptions...
• Select your api user and whitelist the IPs.

I hope this is of some help to you. 

All the best,

Regards,

Daniel