Cannot import data from excel or csv

[Ignacio-G]

Hi! I've been trying without any sucess to import the data tables to the app:

a. First it was about differences in regional settings (changed that to comas as a delimiter) SOLVED!

b. Now I get this 1 error with every table. (NOT SOLVED YET)

Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file 446c4481132941e38689727ae73af2ef.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request.

I am at a lost here... another thing is that when I created the tables it sets a column as an unique identifyer, and I created another one for -for example- Shelter Family (is the unique identifyier that I set when I created the table) and ShelterID is the primary key of the origin table, I do not know if this is generating some kind of issue at all... I leave a pic of it.

I am reading your opinions, anything will help! thanks..

Ignacio

[kfeilen7]

I am having this same exact issue... Anyone answer in a prior thread I missed?

[evahas]

This is what worked for me:

Re: To those not able to import the table data - Power Platform Community (microsoft.com)

[Ignacio-G]

Hi! @kfeilen7 , actually what solved this issue was when I imported the data as a XML data sheet while running the model driven app. It worked pretty well in fact. Thanks @evahas for stopping by.

Best!

[kfeilen7]

Thank you! I found the thread @evahas mentioned shortly after asking. Still having issues on the Animals table. Not sure why it won't import and I've been trying for hours now. 

I feel like its an issue with my columns data types but cannot figure out what. 

Continue to get this error:

Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file 6683565b7f5c4526afed6f98530ced16.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request.

I will try the XML import option. 

[kfeilen7]

The XML import was awesome, it showed me my errors. As I suspected, it was with my data fields for 2 columns. The first I can fix. 

The second one I'm not sure. I guess I set my current location to lookup on the shelter table, however some animals are located with Foster Families, any idea how to remedy this? I can't seem to create the column to reference both tables which is what I think I need to do unless there is another way to do it. 

[kfeilen7]

I found a sample power fx formula to use and corrected it. I believe I have it but the issue I am running into is deleting columns that I messed up on and creating new ones that aren't populating as options when I go to map them. Anyone know, Is there a delay or am I missing something?

[Ignacio-G]

Great you managed to import them! You can delete columns created after previously delete their dependencies (presence in views for example).  But if you have the same issue as me (the previous data imported is still on the tables so its duplicating records...) I guess you can try deleting the imports you don't want in your data?.