Forum Discussion
jmillar
4 years agoHelper I
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...
lbendlin
4 years agoSuper User
Do you know if Query caching is enabled in your tenant?
jmillar
4 years agoHelper I
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.
- lbendlin4 years agoSuper User
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.
- jmillar4 years agoHelper I
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.