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.