Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Excel does not show all the rows inserted



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.



Shiva M

Community Support
Community Support

Re: Excel does not show all the rows inserted

Hi @v-shimud ,

Could you please share a bit more about your scenario?

Could you please share a bit more about the Entity that you mentioned? Is it a CDS Entity?

How do you view the data within the Excel? Using PowerApps app?

Further, do you click "Open in Excel" option in your CDS Entity to view the data?


The user @Sarang24Dev has faced same issue with you, please check my response within the following thread:


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:


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I
Helper I

Re: Excel does not show all the rows inserted

Hi @v-xida-msft ,


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.


Also can powerapps be used as an MDS replacement.


Helpful resources

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Super Users Coming in August

We are excited for the next Super User season.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,834)