SuccessFactors to Power BI - Connection error

Hi sujoydas65,

I'm sure it's too late now but I just had this problem and it wasn't an easy one. The error message is misleading as you can't see the response body from Success Factors.

I found the real problem in my case was that the api user in Success Factors whitelists IP addresses and you need to get the PowerBI Service IP addresses and whitelist them:

Steps:

1. Make sure your API user is set so the password does not expire as this also through 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 

2. 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 (I added both sets of IPs):

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