SuccessFactors to Power BI - Connection error

[sujoydas65]

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

Now the Problem Start - 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 @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

[v-yadongf-msft]

Hi @sujoydas65 ,

The credentials in Power Bi Desktop are just for it. When you publish yo the Service you have to reconfigure the credentials.

The usernames and passwords that you used to sign in to data sources aren't up to date. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

For more information, please refer to: Troubleshooting Power BI gateway (personal mode) - Power BI | Microsoft Docs

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ReneMoawad]

Hi,

Maybe the Authentication Method is different, try using OAuth2

[sujoydas65]

Hello  Rene,

No Luck -