cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-shimud
Level: Powered On

Excel does not show all the rows inserted

Hi,

 

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.

 

Thanks,

Shiva M

2 REPLIES 2
Community Support Team
Community Support Team

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:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Entity-gt-Open-in-Excel-limited-to-...

 

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:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/CDS-Technical-Limits/td-p/115886

 

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.
Highlighted
v-shimud
Level: Powered On

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

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 49 members 4,290 guests
Please welcome our newest community members: