Azure Monitor workbook - In which format should I pass table to visualize nodes relations as Graph

Question

Azure Monitor workbook - In which format should I pass table to visualize nodes relations as Graph

Nikifor Ostanin 0

I'm trying to do simple visualization in Azure Monitor of my entities.

User's image

When I created relations manually:

datatable(nodeId: string, SourceId: string, targetId: string)
[
"node1", "", "node1",
"node2", "node1", "node2",
"node3", "node2", "node3", 
"node3", "node4", "node3",
"node4", "", "node4",
"node5", "node1", "node5",
"node3", "node5", "node3"
]

Then I've got undesired result, containing proper nodes with relations and useless

User's image

Ahat kind of relation should be passed to be visualized as Graph (nodes as unique entities and edges as source-target relations)

1 answer

Your answer

Answer 1

Vinod Pittala 1,600 Microsoft External Staff

Hello Nikifor Ostanin,

I understand that when you are trying to visualize the relations in the graph, you are encountering unwanted nodes in the graphical visualization.

To remove these unwanted nodes, kindly use the following relation order:

datatable(nodeId: string, SourceId: string, targetId: string)
[
"node1", "", "node1",
"node2","node1","node2",
"node3","node2","node3",
"node4", "", "node4",
"","node4","node3",
"node5", "node1", "node5",
"","node5","node3"
]

I have reproduced the issue in my environment and got the same visualization order as you expected.

Please find the below evidence for your reference.

User's image

Output:

User's image

If the provided solution works for your query, please do not forget to click Upvote Button. this can be beneficial to other community members.it would be greatly appreciated and helpful to others

Thanks

Vinod Pittala 1,600 Reputation points Microsoft External Staff

2025-04-16T01:33:44.04+00:00

Hello Nikifor Ostanin,

Just want to check if the above answer worked for you or else please let us know if any help needed, we are always here to help whenever you need us.

Please do not forget to "Accept the answer” and “upvote it” wherever the information provided helps you, this can be beneficial to other community members.it would be greatly appreciated and helpful to others.

Thanks
Vinod Pittala 1,600 Reputation points Microsoft External Staff

2025-04-22T02:03:01.15+00:00

Hello Nikifor Ostanin,

I would like to check if the issue has been resolved or if you need any assistance. Please feel free to let us know, as we are always here to help.

Additionally, if you have a moment, please review my previous Answer.

Please do not forget to "Accept the answer” and “upvote it” wherever the information provided helps you, this can be beneficial to other community members.it would be greatly appreciated and helpful to others.

Thanks

Share via

Azure Monitor workbook - In which format should I pass table to visualize nodes relations as Graph

1 answer

Your answer