Forum Discussion

BIXL's avatar
BIXL
Icon for Resolver I rankResolver I
8 years ago
Solved

Performance best practice with wide tables

Hey All, In general we know that wide tables=bad performance in Power BI models. Say for the sake of the example that I have a 500 columns table that contains a lot of measures and some attributes ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    BIXL

     

    Separating frequently used column and other useless columns so that it will not consume more memory when calling frequently used columns only. For the internal working of VertiPaq engine, you can refer to this article: The VertiPaq Engine in DAX 

     

    Regards,

     

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

BIXL

 

Try to remove useless columns when importing data into Power BI to reduce the data load memory. In your scenario, I think you may split some of columns into dimension tables and connect to fact table on key columns. Depends on usage, you can also include frequently used columns into same table together. 

 

Please refer to an article below:

Data Import Best Practices in Power BI

 

Regards,