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 ?