Forum Discussion
problem with appending
Hi I am a newbie to PowerBI... I have two tables in PowerBI that I'd like to append to a third. They all have the exact same column titles but contain different row data. When I go to append them ...
Hi kconner,
I agree with you and am having the same problem. I can't find anywhere else that anyone else is experiencing the problem.
This is what I have figured out so far.
One of my tables has a column of "Availability" and the other is "availability"
Even though I have read that Power BI is case insensitive, when I append it actually creates 2 columns; one with "Availability" one with "availability".
Then when I click "close and apply" it's like it realises that it IS case insensitive and errors out because the columns shouldn't be separate.
No idea if this is helpful...but at least you're not alone!