Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salesforce: Failed to update data source credentials

Hi Folks,   I have run into a pretty deal breaking issue at the last hurdle of building a fairly big report. The main datasource is Salesforce Objects, I was able to connect and run all perfectly v...
Need Help
metrica's avatar
metrica
Post Prodigy
1 month ago

Since another Salesforce org connects successfully, this likely points to an org-level security setting rather than incorrect credentials.

 

Ask the Salesforce admin to check IP restrictions and “Lock sessions to the IP address from which they originated.” Also confirm that the user has API Enabled permission and that Power BI Service uses the correct supported custom domain, not a Lightning URL. Salesforce is a cloud source and normally does not need to be added as an on-premises gateway source.

 

Power BI Connector for Salesforce by Metrica Software provides another Salesforce-to-Power BI path:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

It will not bypass Salesforce security restrictions, but it can simplify extraction with selected objects, fields, filters, preview, and SOQL support.