Error 0x80020005 power bi

[enath]

Hello

I cannot find the solution for this problem- I checked and there is no date with text format. There is no date at all in my data.

Thanks a lot 

[Anonymous · Accepted solution]

Hi @enath ,

From this error message, it seems to be caused by a mismatch in the data type of the column. Could you please provide which query get the error when apply change on? What steps were applied? Could you please provide a screenshot(mask the sensitive data) of the corresponding query(include the columns name and data etc.)? Before doing so, please delete the applied steps one by one to determine which step might be causing the error. If possible, please share your pbix file (exclude sensitive data) with us. Thank you.

Queries and data

Applied steps

In addition, you can refer to this article below to troubleshoot and see if you can find a solution.

I get a message about data type mismatch

Best Regards 

[enath]

I cannot share the data however you really helped me with your explantion and picture! I think I found the problem. 

thanks!

[amitchandak]

@enath , Open power query do you see any additional error there. A column with red bottom line or any error folder. Check if that contains any additional info

[enath]

no red bottom line or error...