Visual loading time issue

[hoosha_11]

Hi,

I need to optimize the performance of the reports. After investigating using Performance Analyzer and DAX Studio, I think many of the measures need optimization. Most of the measures use the Calculate(Count(...)) or Calculate(DistinctCount(...)) plus some UseRelationship functions, which I haven't been able to optimize much.

Can I create a view in SQL Server and transfer all those measures into that view while maintaining the same logic? Would that improve performance and reduce the visuals' loading time?

Thanks a lot!

[rajendraongole1 · Accepted solution]

Hi @hoosha_11 - Obviously we will better impact in Power BI when we creating a view in SQL Server and moving complex calculations there can often improve performance in Power BI, especially when dealing with large datasets. 

moving complex calculations to SQL Server, you leverage the database's optimized query processing capabilities, potentially improving the performance of your Power BI reports. Just ensure that the logic in your SQL Server view matches your DAX measures to maintain the integrity of your calculations.

Modify your Power BI reports to use the pre-aggregated columns from the SQL Server views instead of the original DAX measures.

Hope it helps.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!