Forum Discussion

sujoydas65's avatar
sujoydas65
Frequent Visitor
4 years ago

SuccessFactors to Power BI - Connection error

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?

Need Help

4 Replies

  • ReneMoawad's avatar
    ReneMoawad
    Icon for Resolver III rankResolver III
    4 years ago

    Hi,

     

    Maybe the Authentication Method is different, try using OAuth2

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

  • danielru's avatar
    danielru
    Frequent Visitor
    1 year ago

    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