Power-Fx PowerFX Filter() on table with more than 1000 record, fails with an error

In many cases, customers would require having Filter() on tables with more than 1000 records. We currently have a VIP customer, who is trying to evaluate PowerFX based low code plugin, and this limitation is blocking their onboarding.

Error - Too many entities in table , more than 1000 rows;

Oct 31 '23 23:10 ramkumarongit

Related to https://github.com/microsoft/Power-Fx-Dataverse/issues/385

Oct 31 '23 23:10 jas-valgotar

This link seems to be broken: https://github.com/microsoft/Power-Fx-Dataverse/issues/385

Nov 25 '23 02:11 jarioksanen

We are seeing this same issue in a low code plugin, and the Filter query should be delegable, but it doesn't seem to be filtering before just getting 1000 rows and throwing an error.

Dec 01 '23 22:12 TarogStar

This should be fixed if you are using DataVerse.Eval nuget >= 1.2.0-build.20231109-1002 If you are still seeing the issue, can we get the expression you were getting the error for?

Dec 04 '23 16:12 jas-valgotar

This should be fixed if you are using DataVerse.Eval nuget >= 1.2.0-build.20231109-1002 If you are still seeing the issue, can we get the expression you were getting the error for?

We are also getting this error. How can we verify which version of the nuget package is being used?

Jan 10 '24 13:01 mortenostigard

@mortenostigard - which product are you using?

Jan 24 '24 17:01 MikeStall