Forum Discussion
Optimize multiple columns to increase performance-
Hi , I have below colummns and in my table which are weekly wise columns for a financial year. now I want to optimize my model and every year new year comes. 1. I tried unpivot columns , bu...
HI,
Unpivot is the correct approach to turn the above wide data into the correct columnar format - so you end up with something similar to columns for Employee, Time and then Hours. You mention 'other columns' in the table - if these are fixed per employee (ie. address, cost centre or similar) then these should be removed into a related (Dimension) table for the employee - leaving only yht eFacts in the 'Hours table'. This will not result in a bloat as the Power BI engine is better at stroing columns of data in lots of rows than many columns as above (columnstore).