The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All,
When ever i create a measure within my power bi desktop, it takes agaes for the formual bar to come up. I have almost 100 mesaures already in my report. Is it because of that ? When ever i click 'New Measure', all slicers, visual starting rolling in that page. Screen shot below. Kindly help.
Solved! Go to Solution.
Hi @KRISH80
It's probably due to the size of your model in general, check your Memory capacity using Task Manager if you are hitting max, then try to optimize your report.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Hi @KRISH80 ,
This should be a memory problem. You can use DirectQuery connection mode.
You can also refer to these articles to optimize DAX performance.
https://maqsoftware.com/expertise/powerbi/dax-best-practices
https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @KRISH80
It's probably due to the size of your model in general, check your Memory capacity using Task Manager if you are hitting max, then try to optimize your report.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Hi @KRISH80 ,
This should be a memory problem. You can use DirectQuery connection mode.
You can also refer to these articles to optimize DAX performance.
https://maqsoftware.com/expertise/powerbi/dax-best-practices
https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.