Forum Discussion
Power 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.
Hi 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
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.
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.
- Yes, that is what I would suggest, best to have it working in the Power BI Service and tweak it from there.