News and Announcements icon

Power Platform CommunityForums Power Up Program - Building model-driven apps w... Help with Importing An...

Power Up Program - Building model-driven apps w...

Unanswered

Help with Importing Animal Table

(1) Share

Report

Report

Posted on by JS-21101630-0

5

I have tried importing the Animal table but the data isnt showing.

I was able to import the other two tables. Is there something I need to do differently with the Animal table? I get a couple warnings about the data type being an integer and updating it to text in the power query editor. The mapping errors go away and it seems to import but then there isnt any data. So I tried it again the next day this time disregarding the mapping errors and publishing. The data still isnt imported.

Can someone please help?

Categories:

General Discussion

Animal table impo...

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 35,193 Super User 2025 Season 1 on at

Like (0)

Report

Help with Importing Animal Table

It looks like the Animal table already exists in Dataverse and the age column is of data type text instead of number. If you delete the age column from your Animal table and re-add it as a number, that should hopefully remove the error. Alternatively if you delete the animal table and choose the option to import into a table, it should create age column and set it as a 'whole number'.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Leaderboard > Microsoft Power Up Program Community

#1

w.p 288

#2

Michael E. Gernaey 138 Super User 2025 Season 1

#3

mmbr1606 80 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans