Hi @MHTANK ,
Here are a few recommendations to address the issues you're facing:
1. Optimize Data Model and Queries.
2.Consider adjusting Power BI Desktop settings related to engine performance, which influence how Power BI handles queries after the Data Transformation step. This includes settings like Maximum number of active connections per source and Maximum number of concurrent jobs.
3.When working with DirectQuery and large datasets, leverage the Optimize ribbon features in Power BI Desktop. This includes pausing visuals before making changes, efficiently using filters, and selectively refreshing visuals.
4.Please check whether there existing any step in Power Query consuming too much CPU or memory. And try to use Table.Buffer to improve the data load performance.
5.When you use measures, they are calculated on the fly, consuming CPU resources. Ensure that your measures are well-designed and efficient. Use DAX studio/ Performance Analyzer to check out which's the most time-consuming.
Please refer to the following documents for more information.
Troubleshoot report performance in Power BI - Power BI | Microsoft Learn
Why my Power BI Matrix or Table Visual is SLOW - RADACAD
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
