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
airwolf39
Helper V
Helper V

How to measure a visual's memory to load

Hi Folks,

 

How can i find out how much memory it takes for a visual to load? It works on my pc but not on the website. I cannot make the measures any more 'lean' than i have already. So my best option is to upgrade the service. But before i give a recommendation i need to know if the service upgrade will handle the visual.

 

Capture.PNG

 

Thanks,

Brian

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

Hi @airwolf39 ,

 

Please try to measure the size of the columns by using DMV queries in Power BI.

 

Analyze memory usage in Power BI to improve performance 

Data Model Size with VertiPaq Analyzer 

 

And you can  refer these links to optimize the data model.

 

How to Optimize Memory Usage? 

Are Your Power BI Performance Issues Due To High Memory Consumption? 

 

 

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Use DAX studio to examine the query produced by the visual.  Most likely a cartesian product  (look at the "Records"  column in the query plan) that you may be able to correct by rewriting the measures that are part of the query.

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.