Salesforce report refresh error online

[SarahT82]

Hi,

please can someone advise, we have the below error when our scheduled refresh takes place.  If we manually refresh our reports on the desktop app we dont get this error and the reports refresh. 

Thanks 
Sarah  

****************************************************************

Something went wrong

There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details.

• MessageThe credentials provided for the Salesforce source are invalid. (Source at https://login.salesforce.com/.) Table: Last two years - all sales.
• Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
• Activity ID9bfa149b-fca3-49f2-a80a-fd57b4f6446f
• Request ID28b0c1b4-943b-954e-a2e8-3fe67fdbbb68
• Time2020-02-11 15:04:15Z

[ReportBuilder07]

Hi, were you able to find a solution? I don't you were presenting that error, but I've used the Salesforce connector and I had some issues refreshing my data sometimes. 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. 

[cARLOSPERALTA]

Hi @SarahT82  @Anonymous  @kyleuk, did you find a solution to this? Thank you in advance!

Carlos Peralta

carlosperalta.dev

[Anonymous]

Hi @SarahT82 ,

According to the error message "The credentials provided for the Salesforce source are invalid.", please check the data source  credentials dataset settings. Otherwise I'd like to suggest you to create support ticket.

https://powerbi.microsoft.com/en-us/support/pro/

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[kyleuk]

Hi,

We have also started having a similar issue, only with our Salesforce connected reports and online.

Posting in the hope this will get more attention.

Kyle