Forum Discussion
Helper IIPower BI Performance : Maximum Number of Visualization per Report
Hi,
My client approached me and asked how many maximum visualization in one report page, so the best performance can be achieved. (currently I used up to 10-12 visualization per report)
Currently, I am using live connection to azure analysis services as a data source, with daily transaction around millions of rows.
the current link
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
only tell "limit the number of visualization" without providing the guidance how to calculate the "limitation", whilist i need to provide the suggestion to client about the range of number visualization
Any suggestion about good source about this ?
thank you
Andre
- Hi Andrew,
The challenge here is that it all depends on how the model is created, how complex or simple the measures are. And then also what visualisations are being used to show the output.
I am not sure how you would be able to define where the drop off point is. I have seen simple visuals take a long time to render (due to complex or poorly written DAX measures) and then seen a large dataset with quite a few visuals on a page return within a second. It is not a simple answer.
5 Replies
- GilbertQ
Super User
Hi there
I would say that having too many visualizations per report will take away the impact and what the report is trying to achieve.
The question should always be asked when creating a report with visuals is what do you want the report consumer to see?
Once you understand that, you can then create the visuals.
I would suggest that less is more.
andrehawariHi Gilbert
Yes, I completely agree with you, less is more. Hence, the client challenged back, how many ?
As the result, I need to propose the logical approach to get into the number.
For instance, with x number of rows, x number of slicers, and x number of data loaded, the performance will dropped down into x second.
Any suggestion for reading material about this will be really appreaciated
Thanks !
Andre
- GilbertQHi Andrew,
The challenge here is that it all depends on how the model is created, how complex or simple the measures are. And then also what visualisations are being used to show the output.
I am not sure how you would be able to define where the drop off point is. I have seen simple visuals take a long time to render (due to complex or poorly written DAX measures) and then seen a large dataset with quite a few visuals on a page return within a second. It is not a simple answer.