Forum Discussion
Web.Contents failed to get contents from Salesforce
Hi,
Our dataset is failing to refresh with this error. This table does exist in our salesforce production instance. Any help here would be appreciated. Thanks
|
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.
Message: Web.Contents failed to get contents from Salesforce (404): Not Found Table: Support SO Item.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 0243d14f-4fef-43e7-906b-8f0450d8ec22
Request ID: 5d62b8ed-cdfe-20cd-2cf8-a799f1a31f4d
Time: 2019-11-12 00:07:35Z
4 Replies
v-frfei-msftCommunity Support
Hi HeenaPat ,
Based on my test, I cannot reproduce your issue here. I recommend you to create a support ticket for help if you are a pro user.
https://powerbi.microsoft.com/en-us/support/
Thank you for your help
ReportGuruPost Patron
Hi, HeenaPat were you able to find a solution? I've used the Salesforce connector but I had some issues imy data too. 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.
- metrica
Post Prodigy
Hi HeenaPat,
A Salesforce 404 here usually means Power BI is trying to read an object or endpoint that Salesforce does not return through the saved query path. I would not treat this as a simple credentials issue.
A few things to check:
Confirm the Salesforce API name of the object, not only the UI label.
Check whether Support SO and Support SO Item are custom objects and whether their API names end with __c.
Confirm the Power BI Salesforce user has object and field access.
Clear Salesforce permissions in Power BI Desktop and reconnect.
If the query is old, try setting a supported Salesforce API version in Advanced Editor.
Remove or disable any old Salesforce queries that are no longer needed in the model.
Another way to validate the Salesforce side is to prepare the dataset before it reaches Power BI.
Power BI Connector for Salesforce by Metrica Software can help: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577
It lets you select Salesforce objects and fields, apply filters, preview the output, review the ERD, and connect Power BI to a prepared source. This can make it easier to confirm which Salesforce objects are actually available to the integration user.
Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/Cheers,
Metrica Team
