Close and apply after importing excel

[stribor45]

Every time I hit close and apply I get this error pop up. After I click on "view errors" it keeps processing forever. How can I actually see these 5 errors without going into this endless spinning? It seems my data is validated since the bar is green under the headers.

Any advise?

[Idrissshatila · Accepted solution]

Hello @stribor45 ,

in this article there's a part called Cell Level errors, check it out

https://learn.microsoft.com/en-us/power-query/dealing-with-errors

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[stribor45]

This is exactly the thing I dont know what those errors are.  The article you shared explain things but still doesnt reveal to me what those errors are. i have no idea whether those are cell or column errrors and my bar is fully green below each column header.

[Idrissshatila]

Hello @stribor45 ,

don't click on view errors, just go to power query and check this table having the error "Pre chat data", there is column or columns that has errors, check them there.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[stribor45]

I am not sure I understand what you mean.  in PQ where would I see these errors?