I have loaded 300000 rows into an entity by selecting the range option in UI, i started the load and shutdown the system as i believe this will be taken care in the backend. However when i try to view the data in excel i am getting exactly 5000 rows.
Question Is : How to check if an entity contains number of rows and how can i load all the rows to excel is there a setting to do that.
For PowerApps CDS platform, there is no hard limit on the number of rows/records. I think this issue may be related to the size of the data you uploaded to your CDS entity. Practically, you are just limited by the database size and storage that you are entitled to or you may have bought.
Please check the response from @SrikumarNair within the following thread for more details:
Thanks for the response, good to know there is no hardlimit on rows inserted into CDS entities.
I am currently doing a POC in powerapps by replicating one of the model we built in MDS. This consists of one master entity and 3 related entities having > 3 million rows as a lookup columns in the master entity. Below are issues i have faced till now.
When trying to load > 3 million rows in child entities i am receiving an error that cannot load more than 500000 rows. By your reply i think this is because i am using a trial subscription and limited by space.
I loaded the data eventually by provide a range (1 - 200000) but when i open that in "Open in Excel " i can see only 5000 rows. Many be this also could be due to limitation it might have loaded only those many rows i think.
If i get this right by getting more storage space, i need to use the child tables > 3 million rows as a lookup in master table. Which means user has to only select or paste values which are in the list. However the only option is to search through the list and select the value. Earlier when i posted this issue got a reply to use functions to lookup the values instead of having users type in, but i cannot seem to use functions in model driven apps. Users will be loading data in bulk.
So is my scenario not supported in model-driven apps?
In my master entity to ensure there is no duplicate rows inserted i have a combination of 6 columns which form unique key which is not supported as a composite unique key in CDS Entity as it only accepts 5 that too should be within a certain lenght. In this case how can i ensure uniqueness of a record with my criteria. In MDS there is a business rule in which we can combine any number of columns to check for duplicate rows. Please let me know if there is any workaround for this.
(Question)I also need to create a custom business rules to check for overlapping dates, can i achieve this. In MDS we wrote a scalar function which can be used as business rule for this scenario. I read about developer documentation of powerapps that we have create a dll.. etc will this work for model-driven app.
Overall we will create base entities and business rules. then create an model-driven app on top of that so users can bulk enter the data abiding by those business rules. We usually would want to store our metadata solution in powerapps.