Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Unanswered

import data on CDS from excel

Posted on by 30

Hi, 

  I create 2 new entities in CDS on power platform.

  when i try to import data from excel workbook to those entities, I can import just 48 entries when I have more than 300 entries ? 

  Is there any limitation when importing data in CDS ? is their any solution of this problem ?

thank you  

  • nkhemji Profile Picture
    nkhemji 2 on at
    RE: import data on CDS from excel

    Did you try dataflow to import the data?

  • LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: import data on CDS from excel

    Hi partner,

    Unfortunately, we could not see the import log now in powerapps, I recommend you to ask this questions in powerapps community as I mentioned above.

    powerusers.microsoft.com/.../197427

    Regards,

    Leo

  • Omaranfer Profile Picture
    Omaranfer 30 on at
    RE: import data on CDS from excel

    Thank you for you replay, I ghange the file to csv format. But it's still limitation on the numbre of entries import, this time is 198 entries. And this rake a lot of time to import data.

     Where can i find logs for this operation ? 

    Thank you 

  • LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: import data on CDS from excel

    Hi partner,

    I tried to created a custom entity in CDS in powerapps and I imported 60 records into it together and it worked well.

    pastedimage1584326971554v2.png

    pastedimage1584326947493v1.png

    And there is also no such documentation about limitation of importing data to CDS.

    So was there any error log or other situation in your case?

    And since you are facing issues in Powerapps, I recommend you to find more professional answers in Powerapps community.

    https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

    Hope it helps.

    Best Regards,

    Leo

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans