On occasions, you may choose to append queries rather than merge them. Here's another example that will explain the difference. You have a list of customers in GP and a list of prospects in CRM. You want to combine them into a single query with Customer ID and Prospect ID in the same column; with Customer Name and Prospect Name in the same column, and so on. This is appending, and Power BI can handle this easily as well.
Let's share a few screenshots with you, rather than walking you through it step by step:
First, we will perform Get Data for both data sources.
We'll need to make sure the columns are in the exact same order (ID, Name, Address, and more) with the exact same column names.
Make sure the columns in both queries formatted the same; for example, the ID column is formatted as text for both.
Highlight one of the columns in the Query Editor and select Append Queries from the Combine area of the ribbon from the Home tab.
If appending Two tables together, select the second...