Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |