Forum Discussion
how to combine data
i have a set of data from one excel file and rest of the data from a another excel file. i would like to combin both the data togather but both data do have different fields. how can do the needful
Can you post some mockup data from each file?
In general guidelines,
a) To decide whether you want to merge or append?
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/
Looks like mostly append in your scenario based on your comments
b) Load first excel file, similarly load second file.
After loading, change columns names and its type that are same in both queries in power bi
c) Append Queries (or) Append Queries as new
hope this helps!
1 Reply
sevenhillsSuper User
Can you post some mockup data from each file?
In general guidelines,
a) To decide whether you want to merge or append?
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/
Looks like mostly append in your scenario based on your comments
b) Load first excel file, similarly load second file.
After loading, change columns names and its type that are same in both queries in power bi
c) Append Queries (or) Append Queries as new
hope this helps!