Forum Discussion
DirectQuery to AAS: Measures return Blank instead of Error after Refresh (Silent Failure?)
Hi rohit1991 ,
Thank you for reply soon!
Since this "known DirectQuery limitation" is rarely documented explicitly in the official Microsoft documentation, I would love to learn more about where this knowledge comes from. I am trying to improve my own ability to troubleshoot these types of backend limitations. Could you share what key reading materials, or technical blogs led you to this conclusion?
Additionally, regarding the MeasureB formula you provided, does this imply that for DIVIDE() to "explicitly guard" the measure and prevent a collapse, the underlying mechanism is effectively forced to act like an IF() statement? In other words, when the model hits its performance limit, does it return a BLANK as a protection mechanism instead of throwing a MemoryLimit? Is this "silent blank" is actually a sign of insufficient hardware resources on the AS side?
Thanks again for sharing your expertise!