cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brian_M
Responsive Resident
Responsive Resident

DMV DISCOVER_CALC_DEPENDENCY "Unsupported dependency node detected"

Hi, 

 

I'm trying to use the model documenter https://data-marc.com/model-documenter/ 

and the following query SELECT * FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY fails. I've tried the same query in DAX Studio and find the same issue:

"Unsupported dependency node discovered"

 

I've traced it back to any queries that used parameters for SQL server and database names.

 

let
    Source = Sql.Database(#"Azure SQL Server",#"Azure SQL Database"),
    dbo_vw_myview = Source{[Schema="dbo",Item="vw_myview"]}[Data]
in
    dbo_vw_myview

 

 

If I replace the parameters with the actual strings for server and database then it works.

 

Surely parameterising the server and database name so that you can update this in one place is a good pattern?

 

Is this a bug or am I using a bad pattern?

 

Kind regards,

Brian 

 

1 REPLY 1
v-xicai
Community Support
Community Support

Hi   @Brian_M ,

 

You may refer to the article: https://www.biinsight.com/dax-measure-dependencies-in-ssas-tabular-and-power-bi/.

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET" to get further help.

 

Best regards

Amy

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!