cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lseow
Frequent Visitor

CDS Row Limits

Hello everyone,

 

I used Get Data to load data from a "Table" within an Excel file stored in OneDrive.  This "Table" has 4000 records. However, only 2000 records were imported into my CDS entity.  I thought there is no row limit in CDS.  Please advice.

 

Thanks,

Lilian

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @v-yutliu-msft,

 

Thanks for responding. I couldn't find anything that would help me in the links you shared.

So I tried another option. What I found out was when I import data from a "Worksheet" not "Table" in Excel, all of the records (more than 2000) would be imported correctly.

So looks like there is a limit when getting data from a "Table" in Excel.

 

Thanks,

Lilian

View solution in original post

2 REPLIES 2
v-yutliu-msft
Community Support
Community Support

Hi @lseow ,

Actally, there's no limit in CDS when getting data from excel.

Here's a issue for your reference:

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

Please check:

1)whether other people open the excel file/CDS when you importing data

2)whether you have these three data type fields:

  • Timezone
  • Multiselect option set
  • Image

These are not limited in importing data.

Please refer this to see whether you have made any mistake:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-import-export

 

 

Best regards,

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

Hi @v-yutliu-msft,

 

Thanks for responding. I couldn't find anything that would help me in the links you shared.

So I tried another option. What I found out was when I import data from a "Worksheet" not "Table" in Excel, all of the records (more than 2000) would be imported correctly.

So looks like there is a limit when getting data from a "Table" in Excel.

 

Thanks,

Lilian

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,460)