Forum Discussion
Append Queries 3 different data sources
The short version of the answer is to create a query for each of your data sources, perform all the neccessary transformations to the source(s) so that they can be appended to the others. Set all of these queries so they do not load into the model. Create a fourth query that has the source equal to Table.Combine({yourFirstQuery, yourSecondQuery, yourThirdQuery).
This approach allows you to manipulate each source seperately so that it can be append correctly.
In the left pane of the Power Query Editor, right click on the dataset and ensure that Ensure Load is checked
Yes it is! the only information showing is the original query I asked to append the rest of the information. the rest is in Null. I have no other errors or anything popping up or showing it is an issue.
Ok. Let's start from the beginning to see if we can find the issue.
Here is an example...
I have three queries tableOne, tableTwo, and tableThree...If I now create a fourth query using
Table.Combine({tableOne, tableTwo, tableThree})I would end up with...
Now, based on your intial post this is not the result you are looking for.
So if, in each of my source tables, I rename my columns to "first" and "second" the resulting combined query should now look like this...
This works because each of the source tables now have the same column names.
If your result is not similar to the above it could indicate that your column names do not exactly match or the table references in your Table.Combine statement are incorrect.I have attached a pbix file with this example for you to review.
Okay I see what you mean now. Power BI forces you to match the column names and not just the order while appending because for example when t1_col1, t2_col1 and t3_col1 are appended, it wouldn't know which column name to keep after appending. Anyway in your report, you would only be able to pick one column name to display in your report header after appending the 3 different columns from 3 sources
Can you show me a screenshot of how it looks?
Power BI forces you to match the column names and not just the order while appending because for example when t1_col1, t2_col1 and t3_col1 are appended, it wouldn't know which column name to keep after appending. Anyway in your report, you would only be able to pick one column name to display in your report header after appending the 3 different columns from 3 sources.