Forum Discussion

danning1234's avatar
danning1234
Advocate I
5 years ago
Solved

DAX Studio, Unsupported dependency node discovered

Hi, i launch the following command to find dependency in DAX Studio and it no longer works. It worked before. Anyone has an idea? I check the measures, there is no "!" marks.   select * from $SYS...
Need Help
  • danning1234's avatar
    danning1234
    5 years ago

    So, finally i found out why it didn't work.

     

    In M, i have a table from SQL Server and i add some custom columns to this table, which is ok, and i referenced this table to create another table. Untill here, tables are fine, it loads to the model, no error message.

     

    However, when trying to do select * from $SYSTEM.DISCOVER_CALC_DEPENDENCY in DAX Studio, i got the error message.

     

    Solution is to stop the referencing, just re-bring the table from SQL and do the rest.

danning1234's avatar
danning1234
Advocate I
5 years ago

So, finally i found out why it didn't work.

 

In M, i have a table from SQL Server and i add some custom columns to this table, which is ok, and i referenced this table to create another table. Untill here, tables are fine, it loads to the model, no error message.

 

However, when trying to do select * from $SYSTEM.DISCOVER_CALC_DEPENDENCY in DAX Studio, i got the error message.

 

Solution is to stop the referencing, just re-bring the table from SQL and do the rest.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey danning1234  so your saying instead of referencing, just duplicate the query?

  • danning1234's avatar
    danning1234
    Advocate I
    5 years ago

    hi Anonymous , according to  my experience, yes.