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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ovonel
Post Prodigy
Post Prodigy

Troubleshooting visuals that take too long to load?

I have a .pbix, and I have a visual that has a matrix with over 10 measures, sometimes it takes 5 minutes to load and sometimes it never loads.

 

Is there a way to exactly pinpoint which measure is causing the visual not to load?

1 REPLY 1
amitchandak
Super User
Super User

@ovonel , check with performance analyzer which is taking time

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

 

if you have a measure that uses related or relatedtable , or any calculation that can be pushed to column instead  of measure do that

 

example

Sumx(Sales, [sales]* related(price[price]) )

 

 

Create a new column and then sum it up

T sales  = [sales]* related(price[price])

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.