Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Excel to New Dataverse Table - Only First 20 Rows

(1) ShareShare
ReportReport
Posted on by 51

Hello,

 

Has anyone else had the same issue? I tried creating a new Dataverse table from Excel data. The table has 313 rows which show they've all been loaded in the preview (see attached photo), and are ready to be created. When I press "Create" and look at the data, only the first 20 rows have been pulled into the new Dataverse table.

 

Am I missing a setting somewhere? Or is this a Microsoft issue? 

 

Thanks,

 

Jason

 

 

07GT_0-1697568986536.png

 

Categories:
  • PF-03101441-0 Profile Picture
    PF-03101441-0 6 on at
    Excel to New Dataverse Table - Only First 20 Rows
    I have the same issue and waiting does nothing. Did anyone find a solution?
  • awilson1 Profile Picture
    awilson1 2 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    Having the same issue after a day of creating the table from an excel file. Any other info on this?

  • aweinburger Profile Picture
    aweinburger 2 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    I've tried this waiting 10 hours for a 1700 row Sharepoint Online List and Excel Export of the same list.  I only ever get the first 20 rows either way.

  • MrGiant Profile Picture
    MrGiant 24 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    Unfortunately all I can import now is blank rows. To say my access to this is totally f**ked would be an understatement.

  • hongkong Profile Picture
    hongkong 232 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    Same problem here. I upload an excel with over 3000 rows but only the first 20 rows is created in dataverse. 

  • Tejaskumar Profile Picture
    Tejaskumar 69 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    Does anyone know why this delay? I'm stumbled upon the same and waiting now if it increases rows in the table or not. So far only 20 rows are visible.

  • MrGiant Profile Picture
    MrGiant 24 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    I have the exact same problem. Uploaded a file over a week ago and it's still only 20 rows

  • Diti Profile Picture
    Diti 37 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    how long is this delay for? it's been a number of days now and i still see 20 rows

  • 07GT Profile Picture
    07GT 51 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    Ok thank you! I didn't realize there would be a delay in upload time.

     

    Jason

  • Verified answer
    FLMike Profile Picture
    FLMike 29,105 on at
    Re: Excel to New Dataverse Table - Only First 20 Rows

    @07GT 

     

    This is because it only tells you it did 20, if you walk away and leave it. Just forget it exists, it will complete them all.

     

    20 is the known initial number in the docs it says its doing, but just let it finish as long as it takes and don't keep retrying etc or clicking create. You'll drive yourself insane.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics