Answered

Importing data from Excel into Dataverse - Problem with missing rows

(2) Share

Report

Posted on by NL-03021738-0

Hi PP community.

I am currently working on my Power Up Final Challenge in the Power Up Program running currently (february and march).
I am working with the case of an Animal Shelter, and are setting up the Dataverse tables in the Power Platform, but when doing the last of 3 supplied excel-files, "Animal Information", I stumble across a problem with importing all the data.

There is supposed to be 50 rows of data + headers, and my imported data only has 41 rows + headers (so i am currently missing 9.
I might also be missing some table-values dependent on the value from one of the other excel-files, but that is to be expected since some of the columns within these files are dependent upon each other.

I used the "import data" to import my data from excel, and chose the file. I have also tried using the "import from Excel", but that gives me an error for some reason.

I hope I can find this thread again, and supply necessary info if needed.

Best regards

Nico

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 53,360 Super User 2025 Season 2 on at

Like (0)

Report

HI,

You will have to share pictures of everything. As the mass majority of us are not in the program we cannot simply go grab the content and try to figure it out.

It will require you to share details, please do so based on the requirement you are trying to make happen and we can help.

Was this reply helpful? Yes No
NL-03021738-0 32 on at

Like (0)

Report

Hi. :)
Of course, I have taken some screenshots, and hope they can explain my problem.
I unfortunately removed my initial table with "Animal Information" from my Power Apps, and haven't been able to find them afterwards, so I made a new one called "Animal Information 1", and have not tried to import the data.

It does, however, show the same problems, and the Power Query (Power forespørgsel in Danish) shows the same correct view as it did the first time, so I am just hoping that some of your experts know what might be the problem.
My only thought is difference in language settings of my Power Apps, and the Excel sheets I am trying to import for my Power Up Challenge.

Power Query impor...

Power Query visua...

Was this reply helpful? Yes No
NL-03021738-0 32 on at

Like (0)

Report

I somehow found out how to add my former table with "Animal Information" in my solutions, and have added the preview we see at the bottom when accessing the table.
As the image shows, there are only 31 additional rows, and given that the preview shows only 10 rows, that adds up to 41 rows.
I added an additional photo of the "import data" process i am using for the "Animal Information 1", so you can see that the data has 50 rows (as well a 21 columns).

Amount of rows an...

Table import with...

Was this reply helpful? Yes No
Verified answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@NL-03021738-0

I'd recommend following these steps for the challenge:
1-create shelter table, columns, view, and form (parent table)
2-create foster family table, columns, view, and form (parent & child table)
3-create animal table, columns, view, and form (child table)
4-create a model driven app
5-import shelter data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
6-import foster family data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
7-import animal data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
8-create a BI report to better understand the next steps, particular table relationships.
9-create canvas app
10-create Power Automate

Was this reply helpful? Yes No