Merging entire tables or just parts of it?

Power BI Data Model
1

Hi there,

After merging a table with fact table, should I expand just the columns that will have calculations done on them and use the other columns in a lookup table or should I merge the entire table with the fact table? What is the best practice?

Thanks!

2

Hello @powerbideveloper,

Thank You for posting your query onto the Forum.

The answer here is - “No, you should not import or merge the un-necessary columns in your table which will not be used for any calculations. It’ll just increase the size or bloat the model. Only bring or merge the required columns that’ll be used or helpful in your calculations or analysis.”

Now, with regards to the best practices, have you gone through the courses - “Data Transformations and Modelling” and “Best Practices & Feature Reviews”? If not yet then I sincerely recommend you to please go through this courses first which will answer all your data modelling related as well as best practices related questions. Below are the links of the courses provided for the reference.

Also I recommed you to please go through the videos of Best Practices which are created by one of our expert @Greg. Below are the links of those videos provided for the reference purposes as well.

Hoping you find this useful and will meet your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

1 Like
3

This is great @Harsh, thanks so much!

4

Hello @powerbideveloper,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh

1 Like