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.
Hello,
I have a question re: combining some data sets and I am hoping someone could please advise?
I need to combine 5 different tables in power bi, potentially these will be in an xls / csv format prior to loading.
The columns in each of the tables are the same but not all tables will have the same combinations of columns (see eg screen shot below and explanation next )-
I realise these could be combined using a union all in sql with place holders added where required in the select statements so that the quantity of columns in tables 2, 3,4,5 match table 1 which has all columns. Would there be a way to do something similar whilst loading the data via power query. I realise there is an append function - but does having a different quantity of columns in each table create issues?
table 1 | |||||||
A | B | C | D | E | F | G | |
table 2 | |||||||
A | C | E | F | G | |||
table 3 | |||||||
A | B | F | G | ||||
table 4 | |||||||
A | B | F | G | ||||
table 5 | |||||||
A | B | F | G |
Regards & thanks
ML.
Solved! Go to Solution.
Hi,
In the Query Editor, the append feature should work without any problem.
Generally now, with Append, common columns will get appended and any columns missing or added between files will be added as appropriate with blanks for the row/column coming from the file without that column.
Generally now, with Append, common columns will get appended and any columns missing or added between files will be added as appropriate with blanks for the row/column coming from the file without that column.
Hi,
In the Query Editor, the append feature should work without any problem.
Just out of curiosity did appending large data set files (including SQL data source related files) take super long for you?
No real problems with this as yet because the sources are still relatively small (>10K records).
Regards,
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |