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
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?

      • jmillar's avatar
        jmillar
        Helper I
        4 years ago

        That I'm not sure about, although I can check.  Is that something that you'd advise trying?  I haven't dealt with that before so should I be concerned about:

        • Adverse affects on other solutions in the tenant
        • Any caching, given the original scope requirement was near-time data

        Thanks, by the way, for your assistance with this.