Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
andrehawari
Helper II
Helper II

Power 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

1 ACCEPTED SOLUTION

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors