Forum Discussion

pauliusmaciulis's avatar
pauliusmaciulis
New Member
10 years ago

SalesForce scheduled synch setup returns error

I work with the PowerBI Desktop version and dashboards are published to the web. The SalesForce login works from the PowerBI Desktop version and I can get the reports data from SalesForce. But when t...
jotaandres's avatar
jotaandres
Helper I
9 years ago

Hi,

 

Any update on this situation? In My case, I cannot connect via PowerBI, getting the error stated on this post, but I cannot connect from PowerBI desktop getting a "Access to the resource is orbiden message". I can login via web with no problem.

 

This was working fine for like 4 months until last Wednesday and we have not made any changes on the slaesforce side.

 

Any help would be really appreciated.

 

Jorge

ReportGuru's avatar
ReportGuru
Post Patron
1 year ago

Hi jotaandres 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.