Forum Discussion
Append Date column
Hi everyone, I have two identical tables with multiple columns. I want to append these tables, which shouldn't be a problem, but Power BI doesn't append the two Date columns. These two columns ha...
Anonymous
it often happens when one of the appended columns contains of space-symbol or tab or smth like [Datum ]
I copied/past both tables to two new Excel-sheets to discover a deviation. I discover one date value was 20-02-2019 instead of 20-02-19. So I changed this and both tables appended with each other. I also changed this value in the original tables, but the still didn't append. I still don't understand why it's working in the new Excel-file, but isn't working in the original file.
Anyway, I decided to copy/paste all values in one new table. It's not ideal, but at least I can continue now.
It would be helpful if PBI was able to give a notification which value(s) are preventing a table to append. It would save a lot of time.
