DataSource.Error: Web.Contents failed to get contents from Salesforce.com

Hi ushah763 (and ramhariessentia who's hitting the same),

The "Web.Contents failed to get contents" error from that URL pattern is a Salesforce REST API URI length issue - when the auto-generated SELECT query (with all fields) exceeds the API's URL length limit, the request gets rejected before any data comes back. It typically starts happening once your object gets wide enough (new custom fields added, relationships expanded, etc.) - which fits the "used to work" pattern.

The Table.SelectColumns workaround that AzAhm posted can help, but only when Power Query folds the pruning step back into the SOQL sent to Salesforce. If it doesn't fold (depends on connector version and where the step sits in the chain), the error persists.

If you'd rather pick fields visually without depending on M-side folding, Power BI Connector for Salesforce on AppExchange is one alternative:

Why it might fit:

• Field selection happens inside Salesforce - the SOQL stays short by construction, no URL length issues
• No 2,000-row limit on reports
• Supports custom fields, custom objects, and joined reports
• 30-day free trial
• Setup docs: https://metricasoftware.com/docs/salesforce/
• Responsive support if you get stuck: https://metricasoftware.com/docs/salesforce/contact-support/

Happy to set up a quick demo if it'd help. Just reach out via the support link.

Cheers,

Metrica Team.