A bit of a conceptual question.....
I have a main data table in Power Query, plus five other tables that I want to "Merge" with the main table, in order to add additional columns of data.
Every time I run a Merge query between the main table and each of the five other tables, there will be a resulting table which is the original main table plus each new column.
I will therefore end up with six copies of the main table in my model, only one of which I actually want to use.
Does this cause an efficiency problem, having all of these "unwanted" tables in my model? Is there a more efficient approach?
I will want to refresh the model every month, so don't Imagine that I can delete the "unwanted" tables?
I have a main data table in Power Query, plus five other tables that I want to "Merge" with the main table, in order to add additional columns of data.
Every time I run a Merge query between the main table and each of the five other tables, there will be a resulting table which is the original main table plus each new column.
I will therefore end up with six copies of the main table in my model, only one of which I actually want to use.
Does this cause an efficiency problem, having all of these "unwanted" tables in my model? Is there a more efficient approach?
I will want to refresh the model every month, so don't Imagine that I can delete the "unwanted" tables?