microsoft / microsoft/Power-Fx

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

Open
#2,008 7 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C#
Stars
3.4k
Forks
358
Avg merge
10h 34m
Merged PRs (30d)
3

Description

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.

image

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

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Search the repository for the Filter() implementation and the exact “Too many entities in table” error, then trace the table-row limit and its tests. Reproduce the failure with more than 1000 records; done means the requested filtering scenario no longer fails because of the 1000-row limitation.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
backend
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.