Forum Discussion
ushah763
Helper I
7 years agoDataSource.Error: Web.Contents failed to get contents from Salesforce.com
DataSource.Error: Web.Contents failed to get contents from 'https://acmeinc.my.salesforce.com/services/data/v27.0/query?q=SELECT%20Id%2CIsDeleted%2CMasterRecordId%2CLastName%2CFirstName%2CSalutation%...
ushah763
Helper I
7 years agop.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
v-cherch-msft
Microsoft Employee
7 years agoHi ushah763
It seems you may check the query.Please have a look at below post to check if it could help you.
Regards,