combine data of two sheets

[Anonymous]

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 with. Is there a way to do it? 

[viviank · Accepted solution]

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.