Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.