Wednesday, 3 January 2018

Optimizing performance of Power BI report


Power BI optimized for handling large data set .
But when you open your report it takes time to load visuals and numbers. Apply below tips for quick report optimization and hence increase the report performance.

  • Remove unwanted tables, columns and filter down rows
One of the best and quickest ways to reduce the pbix file is to remove any unused fields.
How: Click Edit Query > then select the table you want to remove the fields from > Click Choose Columns


        





  • Optimize data type of columns
    • Use integers instead of strings, where possible.→ most of the time we use text column which actually represents a number that will consume all of your RAM in no time. 
      Avoid fields with unnecessary precision and high cardinality→ use rounding on high-precision fields to lower decimal – (like this, 12.49799 -> 12.5).
      → split highly unique datetime values into separate columns – for example, reduce datetime values by splitting the date and time into separate columns or change datetime to date if time is not required

      • Use a star schema when designating table relationships
      Star schema improve query and aggregation performance.


      This consists of a central fact table (i.e. transactions) encircled by dimension (i.e. master) tables. Fact tables will normally include many transactions and have a date/time component.
      Dimension tables normally possess fewer rows and contain (generally descriptive) attributes about the transactions.