To maximize Power BI performance when handling several visuals in a single report page, you can do well if you use these techniques:
Reduce the number of visuals: Limit the visuals on the page to include only the most important. Each one uses up, thus reducing unnecessary visuals and improving performance.
Make it aggregated data: Instead of raw data, show it at a higher level, e.g., monthly aggregates against daily data. This reduces both the amount of data processed and visualized.
Optimize DAX and Queries: DAX-formula optimization is a must to ensure that you have efficient calculations. Avoid complex functions or very volatile (like FILTER and CALCULATE inside measures) as they slow down the computation. Identify what queries are running slow by using the Performance Analyzer in Power BI.
Bookmarks and drill-through hold great promise: Instead of viewing all visuals at a go on a page, bookmark and drill through pages to view details on demand. This helps to clear off the prime page and improves load times.
Use query reduction methods: Limit includes settings that refresh the data and basic query reduction on user interaction. Use slicers when limiting the retrieval of data to make queries less frequent when changing filters or interacting with visuals.
Enable DirectQuery or Live Connection: If the dataset is large, enable DirectQuery or live connections to the data source. Power BI would not query data from your memory but directly from the source, thus increasing your load time depending on the data source.
Use paginated reports: You may want to consider paginating the report or even using paginated reports. These are well-optimized for big data and render very well in most cases.
Optimize the types of visuals: Some visuals, such as maps and high-cardinality charts, greatly lower the reports' performance for reports. Where possible, replace them with more simple visuals or summarized data.
