Forum Discussion

nickchobotar's avatar
nickchobotar
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

DAX Studio 2.7 DMV query $System.DISCOVER_CALC_DEPENDENCY

Hello,   If you have the latest version of DAX Studio, could you please be so kind to test if you can run the following DMV view on any pbix model with DAX Studio 2.7 ?   select * from $SYSTEM.DI...
Interesting Links
Need Help
AlbertoFerrari's avatar
AlbertoFerrari
Icon for Most Valuable Professional rankMost Valuable Professional
8 years ago

Hi,

 

Just tried a few seconds ago, and it works as expected.


Have fun with DAX!

Alberto Ferrari
http://www.sqlbi.com

Kesney's avatar
Kesney
New Member
8 years ago

I have an SSAS 14.0.1.440, with two tabular databases, on one I get the same error reported here, on the other it works fine.  It looks like this error is model specific.  Any thoughts on what could be wrong with my model?  Both models are in 1200 compatibility mode.

  • nickchobotar's avatar
    nickchobotar
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Kesney

     

    I my case I was testing this DMV on a Power BI model with the a local instance of analysis service and it turned out to be a bug. It was fixed with the latest February 2018 release but before that you could not run DISCOVER_CALC_DEPENDENCY on 5 consecutive Power BI releases.   When I discovered this bug I tested this on my SSAS models too and all worked fine.

     

    In your case, I will agree with you it does seem to be model specific, since you are able to get it to work on one of the models. 

     

    N -