Forum Discussion

AnjaW's avatar
AnjaW
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
2 years ago

Thanks Ibendlin, this sounds a promising way forward. I am new to using the diagnostic tool. Can you help me how I can tell whether a custom SQL query is produced or not? I get a handful of diagnostic tables, which one is the crucial one? Which column to scan for what kind of entry. Thank you so much!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

For starters you can use the agg table.

 

Don't forget to delete these table groups when you are done.