Unanswered

Dataflow to Dataverse only 5000 rows

(0) Share

Report

Posted on by sncueto

Hi,

We are using Dataflow in order to import masive data into dataverse, but recently realized that only 5000 rows were imported (we tested XML and Excel files). I´ve been looking at documentation and I haven't seen specified this limitation. It´s a real limitation? Or is there a way for importing a bigger amount of rows? (pagination or increasing somehow the number of rows).

Regards and thank you for your help.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

sncueto 19 on at

Like (0)

Report

After analyzing it further, we realized that the process was running correct, it´s just that Dataverse mention that only have 5000 records, but the fetchxml count query finds the correct number. Just in case happens the same to other.

Regards.

Was this reply helpful? Yes No
sauravraj62 Microsoft Employee on at

Like (0)

Report

Hey @sncueto ,
Which query you used and where? Can you please share some context on the same?
I'm also facing similar kind of issue. Copied 0.1M rows in dataverse table but it's showing only top 5000 rows.

Thanks in advance.

Was this reply helpful? Yes No
sncueto 19 on at

Like (0)

Report

Hi @sauravraj62 ,
Sorry for delay, we were using Dataflow to load some unestructured Excel data into Dataverse table. It seems that only 5000 records were loaded but doing deeper checks we saw that it was only related to the limits of recovering records for our kind of license, so everything was ok.

Regards

Was this reply helpful? Yes No
Naresh_Bittu 4 on at

Like (0)

Report

Hi Guys,

Dataflows can be used to import millions of records in an hours.

I have done POC and adding the results here, we can import 1 lakh of records from excel with in 14 to 18 mins
& we can import 1 millions of records form excel with in 3 hr.

Regards,
Naresh B2

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

How to do this? Using dataflow from Dataverse Table to Dataverse Table only 5000 rows.

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

How to do this? Using dataflow from Dataverse Table to Dataverse Table only 5000 rows.

Was this reply helpful? Yes No
Michael E. Gernaey 53,351 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You are taking records from one table to another in the same instance?

Also by default the max records retreived BEFORE you need to use the token to get more is 5K. So it sounds like either A) you only have 5k records or B) you aren't using pagination to continue to get records.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

How to using pagination in dataflow?

Was this reply helpful? Yes No
Naresh_Bittu 4 on at

Like (0)

Report

Yes i imported from excel(not from dataverse table) to Dataverse(D365) custom table , i seen millions of records in advanced find too.

Was this reply helpful? Yes No