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
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
→ 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.
Dimension tables normally possess fewer rows and contain (generally descriptive) attributes about the transactions.
