Forum Discussion
DataSource Error from SalesForce object
Your WHERE statement is incomplete. At the bare minimum it will need to say TRUE=TRUE but more likely you are missing a filter column.
I'm receving a nearly identical error when trying to expand account object fields. I understand that in the error displayed, the statement is incomplete; however, I don't see a way to edit the soql query directly (if I could this would be super easy to resolve). I'm not sure what you mean by 'missing a filter column'. Can you please elaborate on what the issue might be and how to correct?
Super UserShow your Power Query code please.
Hello, I don't know if the issue has already been adressed and resolved.
Anyway I'm getting the same error than Guillermo.
Please find below steps that I have made:- Load Account data from Salesforce source --> The stand alone table works fine
- Load Competitor data from Salesforce source --> The stand alone table works fine
- Join the above table to get the competitor accounts details -->
- The "join" step works properly
- The "expand table column" steps got this error: SELECT Id FROM Account WHERE TRUE
I got the issue even if i try to recreate the step from zero.
Please find below the power query code related to steps 3.1 and 3.2:
3.1 Code: = Table.NestedJoin(#"Removed Other Columns1", {"Competitor__c"}, #"Competitor Details 01 - Account", {"Id"}, "Competitor Details 01 - Account", JoinKind.Inner)
3.2 Code: = Table.ExpandTableColumn(#"Merged Queries", "Competitor Details 01 - Account", {"Id"}, {"Competitor Details 01 - Account.Id"})
