Performance degradations for classic PBI Matrix visual, custom Matrix visual and Analyze in Excel

Kerstin111 

It sounds like you're experiencing significant performance issues with classic Power BI Matrix visuals, custom Matrix visuals, and Analyze in Excel functionality for your semantic models. Here are some thoughts and potential solutions to address these issues:

1. **Performance Tuning**:
- Review the performance of your semantic model and consider optimizing it for better performance. This may involve optimizing DAX measures, reducing the complexity of relationships, and optimizing the data model structure.
- Use the Performance Analyzer in Power BI Desktop to identify bottlenecks and optimize query performance.

2. **Review Data Volume**:
- Analyze the volume of data being queried by your Matrix visuals and Analyze in Excel reports. Large datasets can significantly impact performance, especially when using visuals with many data points.
- Consider implementing data reduction strategies such as applying filters, limiting the number of rows displayed, or aggregating data where possible.

3. **Evaluate Custom Visuals**:
- Custom Matrix visuals, especially those from third-party providers like Zebra BI, may have different performance characteristics compared to standard Power BI visuals.
- Reach out to the vendor or developer of the custom visuals to inquire about any performance optimizations or updates that may be available.

4. **Analyze in Excel Troubleshooting**:
- Investigate the specific queries being generated by Analyze in Excel reports and identify any patterns or commonalities that may be causing performance issues.
- Consider reviewing and optimizing the data source connection settings, including query folding and data load options, to improve performance.

5. **Engage Microsoft Support**:
- Continue working with Microsoft Support to troubleshoot and resolve the issues you're experiencing. Provide them with detailed information, including sample files, query logs, and any error messages encountered, to help expedite the resolution process.

6. **Consider Premium Capacities**:
- Premium capacities offer enhanced performance and scalability compared to shared capacities. If performance is critical to your organization, consider leveraging Premium capacities to host your Power BI workloads.

7. **Stay Informed**:
- Monitor the Power BI community forums, blogs, and release notes for updates, announcements, and best practices related to performance optimization and troubleshooting.

By following these steps and collaborating with Microsoft Support, you should be able to identify and address the performance issues affecting your Matrix visuals and Analyze in Excel reports. Remember to prioritize optimization efforts based on the specific requirements and constraints of your organization.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!