Forum Discussion
Helper VReferencing vs Duplicating to Create Dimension Tables
Hi newpbiuser01 ,
When working with large data tables, it is important to optimize the data model to improve performance. One way to do this is by breaking down the master data table into dimension tables, as you have done.
In your case, it sounds like referencing the master data table to create the dimension tables is the better approach, as it has resulted in a significant reduction in data refresh time. Although Power BI may hit the main data source multiple times when refreshing the dimension tables, the overall performance is still better than when duplicating the data table.Solved: Difference between Reference and Duplicate - Microsoft Fabric Community
Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD
How to Get Your Question Answered Quickly
If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi newpbiuser01 ,
When working with large data tables, it is important to optimize the data model to improve performance. One way to do this is by breaking down the master data table into dimension tables, as you have done.
In your case, it sounds like referencing the master data table to create the dimension tables is the better approach, as it has resulted in a significant reduction in data refresh time. Although Power BI may hit the main data source multiple times when refreshing the dimension tables, the overall performance is still better than when duplicating the data table.
Solved: Difference between Reference and Duplicate - Microsoft Fabric Community
Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD
How to Get Your Question Answered Quickly
If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IHi. I am running into the same dilemma. Considering you attempted this an year ago, I am wondering if you have a winner between the two approaches for large master tables?