Forum Discussion
combine data of two sheets
Hi community, I have a two data sheets, the data is just split into two excel sheets because of the size. so when I try to upload the data in power BI how do I combine the two sheets to work wit...
Yes, this is pretty easy. In Power Query, use the button Append Queries.
Then choose your two data sources in Power Query and combine them into one.
To get this done right, you need to rename the fields first so they're the same in both sources.
viviank
Resolver I
Resolver IYes, this is pretty easy. In Power Query, use the button Append Queries.
Then choose your two data sources in Power Query and combine them into one.
To get this done right, you need to rename the fields first so they're the same in both sources.