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.
Go to Solution.
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.
View solution in original post
Hi @lseow ,
Actally, there's no limit in CDS when getting data from excel.
Here's a issue for your reference:
1)whether other people open the excel file/CDS when you importing data
2)whether you have these three data type fields:
These are not limited in importing data.
Please refer this to see whether you have made any mistake:
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020