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 nea...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

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

jmillar's avatar
jmillar
Helper I
4 years ago

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
    4 years ago

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

    • jmillar's avatar
      jmillar
      Helper I
      4 years ago

      lbendlin There is a gateway involved.  Originally the solution was in DirectQuery mode, but for troubleshooting purposes I've switched it to Import with an hourly refresh schedule just to eliminate gateway bottlenecks, etc....

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Do you know if Query caching is enabled in your tenant?