Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.