Forum Discussion
Helper IIs OData no longer supporting Query Folding?
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
Helper IOK. And then? I don't see anything relating to SQL in the entire table. What should it look like if query folding is happening?
Super UserHere'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
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.
- lbendlin
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .