Forum Discussion
Slow Service visual
Hi all;
I'm having some difficulty with the following visual:
There are a few other measures as well. Originally this was a composite model with direct query components (the mandate is a near-time OEE view for the current production day) but for troubleshooting purposes I've convert it all to Import. The entire data set is maybe 1200 records (max). In Desktop, the visuals all refresh pretty snappily (1-2 second update time). In the service, though, they seem to take longer. There are several visuals on the page, and most update in under 5 seconds which I consider acceptable. The table shown above, though, can take upwards of 4 minutes!
I'm at a loss to troubleshoot further to explain why local performance in desktop is acceptable, while performance in the service (both browser and mobile app) are abysmal. Does anyone have any suggestions?
UPDATE: I believe I've narrowed this down to the conditional formatting on the matrix. Remove that, and it speeds up. The conditional formatting is set using field values, though, as the stoplight thresholds don't have static targets -- they need to be calculated. Has anyone else experienced this and/or found a solution?
Thanks,
Jason
8 Replies
- lbendlinSuper User
Use DAX Studio to evaluate the queries generated by this visual.
- jmillarHelper I
Thanks lbendlin -- I had actually started down that road. I grabbed the DAX generated by the visual, and when I run timing against that in DAX Studio results return in ~300-400 ms, which is what I'd consider acceptable. However, I'm new to trying to performance tune models -- most of ours have been relatively straightfoward that, for the most part, "just behave".
- lbendlinSuper User
Is your data source in Import mode or direct Query? Any gateway involved?