Forum Discussion

AnjaW's avatar
AnjaW
Helper I
2 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    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's avatar
AnjaW
Helper I
2 years ago

Ahhh, I see. Thank you! You are right, it does still fold. 

So I am back in the dark why the refreshes are failing.

 

I appreciated your help. I have learnt a lot for the future.