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

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

    Thanks

    $SYSTEM.DISCOVER_CALC_DEPENDENCY  view works on PowerPivot and SSAS models but it does not work for Power BI pbix models.  DAX Studio  is NOT causing this. I used localhost ports and connect to pbix with SSMS and still get the same error. 


    The primary diagnosis is the AnalysisServicesWorkspace Power BI is running on.  Has anyone had a similar issue ?

     

     

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

    Hi  AlbertoFerrari

     

    It appears the problem is with the Power BI October release. My coworker that happens to still have a September Power BI release, is the only one who does not have any issues running $System.DISCOVER_CALC_DEPENDENCY.   When you did the test today, was it October or September Power BI release?

     

    Thank you very much, Nick -

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