Append tables with different column names but similar data

[Muki]

Hi all

I'm looking for a solution to append multiple tables into 1 table without renaming initial column names.

Reason why I cant change the column names is because that was the initial situation in my reports. I have to find another solution to append my tables as the 'scheduled refresh' functionality in PowerBi Server apparently doesn't support non-unique column names.

So table C is what I would like to get:

Thanks in advance for any suggestions!

Muki

[MattAllington · Accepted solution]

Inside the query editor, you just connect to both source tables.  From there you can rename the columns regardless of what is in the sources. Then append from there

[Oxigeno]

Could you be more specific, pleas? I do not follow you. How to connect both source tables?

txs