Forum Discussion
DataSource.Error: Web.Contents failed to get contents from Salesforce.com
p.s.
i tried reducing the query to only a few columns, this didn't work:
let
Source = Salesforce.Data("https://acmeinc.my.salesforce.com/", [CreateNavigationProperties=true]),
Lead = Source{[Name="Lead"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Last_Status_Date__c", "Last_Converted_Status_Date__c", "Id", "Lead_Owner_Name__c","Name", "Title", "Lead_Owner_Sub_Territory__c", "Company", "State", "Country", "Phone", "Email", "CreatedDate", "LastActivityDate","Status", "DoNotCall", "Lead_Account_Sales_Program_Type__c", "Account_Type__c","ActivityHistories","LS_Status__c" })
in
Lead
Hi ushah763
It seems you may check the query.Please have a look at below post to check if it could help you.
Regards,
That does not help. I already tried selecting select columns in the editor, but it seems i need to do so in the initial query to salesforce.com and not sure how to do that. The post you referenced does not show that either.
