CODEWITHSUNDEEP
powerbisalesforcedatasourcecredentials
unnikrishnan
unnikrishnan

Reputation: 151

Unable to validate salesforce credentials in power bi service

I am creating a power bi report with multiple tables sources from web and salesforce. when I publish the report and set schedule refresh, I was asked to update data source credentials. I have updated credentials for web data sources. but when i update credentials for salesforce, its giving me an error

enter image description here

I am able to validate the same credentials in power bi desktop and it works without any issue. but only on power bi service, I am getting this error. Not sure what could be the issue here. please help.

Upvotes: 0

Views: 1545

Answers (1)

eyescream
eyescream

Reputation: 19612

Go to Salesforce, find the connecting user and at the bottom there should be login history. Do you see any errors there? Maybe "Restricted IP" (ask your SF admin to check this user's profile & allowed login IP ranges), maybe "Security token required" (ask sf admin, there's something you need to append at the end of password)...

If your app uses "connected app" (set of OAuth2 keys) there might be some config in SF needed like "all users can self authorise" or add your server to list of allowed callback urls...

Upvotes: 2

Related Questions