Forum Discussion
AnjaW
Helper I
2 years agoIs 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...
- 2 years ago
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
AnjaW
Helper I
2 years agoAny idea what else could be the underlying issue to generate this error message:
I stress again, no changes have been made to the data model and it has been refreshing without issues for months...
lbendlin
Super User
2 years agoLast service version change was on 5/12
But your error message clearly points to data quality issues on your side.