Forum Discussion

jmillar's avatar
jmillar
Helper I
4 years ago

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

  • Use DAX Studio to evaluate the queries generated by this visual.

    • jmillar's avatar
      jmillar
      Helper 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".

      • lbendlin's avatar
        lbendlin
        Super User

        Is your data source in Import mode or direct Query? Any gateway involved?