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
Solved! Go to 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
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
Could you be more specific, pleas? I do not follow you. How to connect both source tables?
txs