Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Where's my data, am I being thick? (Excel Import)

(0) ShareShare
ReportReport
Posted on by 55

The import to 'create new table' completed successfully, and I can see the table has been created. Unfortunately the data isn't showing, I assume I'm missing something?

 

Capture1.JPG

 

Capture2.JPG

Categories:
  • Verified answer
    johnbradbury Profile Picture
    55 on at
    Re: Where's my data, am I being thick? (Excel Import)

    I've managed to resolve the issue. It appears to be the field types which auto-detected on my spreadsheet, I didn't fully check them during the transform part of the import and clearly put too much faith in the detection algorithm. Once I manually changed the field data types the import worked.

    In some cases the field type had been detected as a number but was actually alpha numeric.


  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on at
    Re: Where's my data, am I being thick? (Excel Import)

    Hello @johnbradbury,

     

    One more Quick Check Please, Click on Gear Icon(rampprakash_0-1634648171177.png) at the top then Click on Advance Settings --> Then Select Data Management --> then Select --> Imports --> Change the View to ALL IMPORTS --> Then check the Import Data Status.

     

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • johnbradbury Profile Picture
    55 on at
    Re: Where's my data, am I being thick? (Excel Import)

    It creates the table (entity), but no data shows. If I look at the import it shows as successful, bizarre.

     

    It’s the same for at least three people in my team , all with the environment admin role.

  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on at
    Re: Where's my data, am I being thick? (Excel Import)

    Hello @johnbradbury,

     

    That was Strange. Can you let me know weather the entity is Created or not.

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • johnbradbury Profile Picture
    55 on at
    Re: Where's my data, am I being thick? (Excel Import)

    I don’t think it’s just me. Others in my team have the same issue. Any thoughts?

  • johnbradbury Profile Picture
    55 on at
    Re: Where's my data, am I being thick? (Excel Import)

    The entity name was 'people-test', this entity didn't exist before the import (as I set the import to create this new entity 'import to new table').

     

     

  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on at
    Re: Where's my data, am I being thick? (Excel Import)

    Hello @johnbradbury,

     

    Could you please check the Entity name which you have selected while importing.

     

    Please mark as Answer if it is helpful and provide Kudos

     

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

     

    Blog : https://microsoftcrmtechie.blogspot.com

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics