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

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.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      When you examined the DAX query in DAX Studio did you do that against the local dataset on the Power BI Desktop or against the XMLA endpoint in the service?  I would recommend to do the latter so you get a more realistic reading on the performance.

      • jmillar's avatar
        jmillar
        Helper I
        4 years ago

        Now that you mention it, I believe I was using the Desktop version.  Let me try it against the endpoint and see what that shows.