Appending 2 Queries to stack data

[Dexter1088]

Hi There!

My Goal is to stack data from 2 tables that are not related.

My 2 tables are like this

LAT	LONG	Type
82736	23049	Retail Store
74466	23039	Retail Store
73094	27282	Retail Store

LAT	LONG	Type
83684	82475	Dealer
83753	84852	Dealer
83759	33823	Dealer

How do I get them combined so theyre in 1 Table like this?

LAT	LONG	Type
83684	82475	Dealer
83753	84852	Dealer
83759	33823	Dealer
82736	23049	Retail Store
74466	23039	Retail Store
73094	27282	Retail Store

I want to do this so I can MAP everything on 1 layer and color it by Type

Thanks!

[MFelix · Accepted solution]

Hi @Dexter1088 ,

On the query editor select one of the tables and do an append, that will give you the expected result, you then should disable the other table from being loaded.

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

Regards,

MFelix