Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am finding that as we get more and more requests for analysis my reports are growing with the number of tabs. I am assuming that when power bi service refresahes ALL calcauted columns are refreshed, but it only needs to calculate measures where they are employed in a visual? So the more tabs I have the longer it takes to do the refresh. Have i got that right or makes no difference?
Secondly what happens if I use the same measures on different visuals. Does Power BI cache these in anyway or has to do a seperate calcuation for each one i.e. am I better off to try and use a single visual with various filters/slicers than to create a seperate report? i end up duplicating visualls for example one for current month split by store and another for monthly at group level. I'm guessing this is i twice as much processing.
Thnaks ofr any advice on best practice
Mike
Hi @masplin,
The more visuals/measures you have and the more complex DAX formulas you created, the longer time it would take to refresh report.
Below are two articles for your reference to improve the Power BI report performance:
Power BI Performance Best Practices
Power BI performance tips and techniques
Best regards,
Yuliana Gu
So is it true that having one page with a set of measures and multiple slicers is better than having the same measure on 2 pages to offer 2 differnet views?
Thnaks
Mike
Hi @masplin,
Yes. As suggested in the document, it would be better you could limit the number of visuals in a single report file.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.