Forum Discussion
Question about reporting writing efficiency and multiple tabs
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
3 Replies
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
