Forum Discussion
Solved
Is OData no longer supporting Query Folding?
My semantic model no longer refreshes. I have made no changes whatsoever myself. The error message is identical to those when a nested merge is performed on tables from different sources with restri...
Here's an example for Salesforce Objects
let Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]), Account1 = Source{[Name="Account"]}[Data], #"Filtered Rows" = Table.SelectRows(Account1, each Date.IsInPreviousNDays([CreatedDate], 30)) in #"Filtered Rows"This query allegedly doesn't fold
Running the diagnostics however reveals that it does indeed fold into custom SOQL. Check the "Data Source Query" column.
Request: GET https://xxx.my.salesforce.com/services/data/v48.0/query?q=SELECT Id%2CName%2CCreatedDate FROM Account WHERE ((CreatedDate>%3D2024-04-17T00:00:00-04:00) AND (CreatedDate<2024-05-17T00:00:00-04:00)) LIMIT 1000 HTTP/1.1
It's NOT folding.
I used the following script from Brunner BI, who took it from Chris Webb.
GetMetadata = Value.Metadata(#"MY LAST STEP"),
QueryFolding = GetMetadata[QueryFolding]
in
QueryFolding
I will contact support as you suggested. Thanks for having help me getting to the bottom of this.
It's meaningless. Check the actual query.