Forum Discussion
salesforce - data source can't be refreshed because the credentials are invalid
I have successfully linked my Salesforce account and objects to a PowerBi report. This is created in the desktop application.
When I refresh from here, the data updates perfectly.
However the published data does not update and tells me that I have invalid credentials.
When I try and connect to Salesforce, I enter my password and get the following error.
Can you please tell me why?
9 Replies
Hi Anonymous,
I can reproduce this issue on my side. I already report it internally, will update here once get any information.
Best Regards,
Qiuyun YuHi Anonymous,
I’ve got response from the Product Team.
In the most recent example, the Salesforce service is returning an HTTP 403, meaning "this account does not have permission to perform this operation". We don't know why Salesforce would return this error, and customers may need to contact Salesforce support to find out why.
Best Regards,
Qiuyun Yu
Hi Anonymous were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:
After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:
There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi there,
Microsoft confirmed that Salesforce returned HTTP 403, meaning the account was not permitted to perform the operation. Check API Enabled, the Salesforce edition, and access to the required objects and fields.
If the permissions are correct, Power BI Connector for Salesforce offers an alternative token-based connection while still respecting Salesforce access controls.
AppExchange and 30-day free trial:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/Cheers,
Metrica Team
