SuccessFactors to Power BI - Connection error

[former_member83792]

error1.pngHi All,

Greetings for the Day,

I am connecting Power BI Desktop app to SuccessFactors via Web

All looks good and Data is flowing from SF to Power BI Desktop app.

error.png - I have Publish the app now to online version of power bi.

When I try to refresh the Dataset - It says following error

Processing error:The credentials provided for the Web source are invalid. (Source at https://api2.successfactors.eu/odata/v2/EmpJob.)

Same credentials work in Power BI Desktop version but not on online version.

Any Idea What could be the issue?

[danielru]

Hi @former_member83792 ,

I had this same frustration for a long time. Power Desktop works but the moment you publish to the service you get this invalid credentials error.

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 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

[phoebemomo37]

Good morning! I didn't even know it is possible to connect to Power BI Desktop app to SuccessFactors via Web. Is there any documentation I can find online?

[nlgro02343]

I've had that a couple of times too. Even though the code to pull the data was the same, there were 2 things causing this issue for me:
1. PowerBI all of a sudden struggled to combine several queries of mine. I narrowed down to the spot where I would first get the error to cut up the process more. In the end it looked like this for me:
= Xml.Tables(Web.Contents(URL&"/"&Entity))
I had made variables for URL and Entity to ensure I could easily swap between data centers and Entities.
2. The connection statement I used had to be redone
3. The Webversion may not properly store the credentials correctly, you may wish to reapply them.