Report refresh and calculated column changes takes long time to apply

Convert as many calculated columns to custom columns in Power Query. Depending on your data source, you may get much faster results of the calculations are sent back to a relational database, like SQL.

Data coming in from Power Query also gets treated as imported data in the DAX model, so it is compressed and needs no additional RAM or CPU to process, as it is pre-processed before it is imported.

Calculated columns should be used sparingly and in specific circumstances. It isn't impossible, but it is rare to get better peformance from them than from custom columns in Power Query.

Hi dilkushpatel ,

check this videos...

VertiPaq Analyzer

https://www.youtube.com/watch?v=1A7gFFvlRFI

https://www.youtube.com/watch?v=frTcFzdxHH4

Debugging a slow Power BI report

https://www.youtube.com/watch?v=eABg872TAJU

...and this blog post.

https://www.sqlgene.com/2019/09/27/a-comprehensive-guide-to-power-bi-performance-tuning/

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

dilkushpatel ,

Please check if there're any useless DAX formula in your report. Make sure each column will be used, remove the useless columns. For more details about how to improve the query in power bi, I would suggest you refer to doc below:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.