Forum Discussion
DataSource.Error: invalid query locator when expanding a column
Hi All, I'm trying to expanding a column from two merged queries. Both queries are from two separate salesforce objects. The second one only has one column called Materials. However, when I try ...
Encountered this error using SalesForce Opportunity Line Item table. Created a copy of that table, filtered the rows, renamed columns and grouped the data. Then attempted merge using an imported ForeCast table. The workaround is to change the JoinKind from LeftOuter to Inner.
= Table.NestedJoin(#"OpportunityLineItemGrouped",{"FYQ", "Region", "SubRegion", "Product Line"},Target,{"FYQ", "Region", "SubRegion", "Product Line"},"Target",JoinKind.Inner)
Also, found this link in SalesForce help
https://help.salesforce.com/articleView?id=000004410&type=1
HTH,
Smitty