Hello,
i have not found any value for the max. limit of filter in Dataverse,
as its is a delegable function i assume it should be pretty high, but i guess there is a limit?
From a extremely large Dataverse Table 1.000.000 + Data-Sets i would like to create a collection which i can process afterwards.
the Dataverse Table is a software extract with all labor, equipment costs for all projects since 2021 (there are some long Term projects)
this would be my formular:
ClearCollect(col1;Distinct(Project_Costs;projectNumber));;
ClearCollect(col2;AddColumns(col1;"LC";Sum(Filter(Project_Costs;ThisRecord.projectNumber=projectNumber);labor_costs)));;
it is writing down the Project Numbers but for the "LC" column it says network error in the column, thats why i assume there are to many datasets.
Calculation takes something like 15 seconds and its not writing any error.
has some one experience processing that much data, is there a limit at 1.000.000+ records?
thanks
