Question
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customer.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do?
Explanation
Option to use to combine the Customer tables: the tables have the same columns, so their rows must be stacked with an append, not joined with a merge. Append Queries as New creates a separate combined query while leaving both source queries intact. Action to perform on the original two SQL database queries: disable loading them to the data model so only the combined table is stored, which minimizes model size. They still run during refresh because the combined query depends on them; deleting them would break the append, and excluding them from report refresh would stop the combined table from getting new data.
