Forum Discussion
Helper IIPower BI Performance : Maximum Number of Visualization per Report
- 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.
Super UserI 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.
Helper IIHi 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.- andrehawari
Hi Gilbert
Well noted, thanks for the input.To summarize, there are 3 factors to consider based on your answers
a. how the model is created
b. measures complexity
c. type of visualization (I wonder why this is matter, let say are there any differences if we choose bar chart over line chart ?)
It looks like the only way to calculate the performance is only after the system go live with real data, then do the tweaking.
- GilbertQYes, that is what I would suggest, best to have it working in the Power BI Service and tweak it from there.