merging multiple data scouces

[bi-bi_9]

Is it possible to merge two dataset from diffrent scources.? With the assumption that the sources have similar data types. Let's say that one scource is an Azure Sql table and the other an Excel file.

[Daryl-Lynch-Bzy · Accepted solution]

Hi @bi-bi_9 , yes.  Append queries - Power Query | Microsoft Learn.

Note the tables don't need the same columns names, number of columns or data types, so you will need to check after merging.  It is best to clean before merging.  However, depending on your use case, you may not need to merge the tables.