DARTS : Data Model Optimization with DAX Studio

DAX Studio can be used for Model Optimization in Power BI.  Downloaded DAX Studio from https://daxstudio.org/.

1. Open both DAX Studio and PBI file. Choose "PBI /SSDT Model"  on pop-up window.
   
   
   
   
2. Go to Advance tab and click "View Metrics"
   
   
   
3. On "Tables" tab, you can see table list by size.  Review each table. You can also expand the table and list of fields will show up. 
   
   
   
   
4. On "Colums" tab, you can see all of the fields at once. Look at cardinality and column size. Review for the large fields.
   
   
   
5. On "Summary" tab, you can see the size of the model. For P1, more than 3GB compressed size will affect the performance issue. 
   
   
6. Delete columns you don't need in Power BI. Smaller is better.
   1. In PBI, when you delete the columns, it automatically creates a  query
      

Tips for reducing the size

• Import the data you really need only. Don't pull unnecessary columns and rows. Limit years of data
• Check Data type : decimal to whole number. Date/ time to Date.
• Avoid using calculated columns: use measures
• Disable Auto Date/ Time option for data load (Option > GLOBAL> Data Load > Auto date/ time for new files. It also has under CURRENT FILE > Data Load > Time intelligence)
  
• Uncheck "Enable to Load" if the model don't use the query
• Do all the transformation if you use native query