Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have created node and edge tables in SQL Server 2017 (Graph tables) and was able to import them into Power BI desktop. Are there any blogs or examples that can help me get started with consuming this and visualizing this data?
Thanks
I am using CTP2 and have some data loaded in node and edge tables. I have imported the tables into the Power BI desktop. How do i develop a data model and visualize the hierarchy data? I could not find any examples or documentation. Any pointers / suggestions will help. thanks. Nars
@narsiman wrote:
I am using CTP2 and have some data loaded in node and edge tables. I have imported the tables into the Power BI desktop. How do i develop a data model and visualize the hierarchy data? I could not find any examples or documentation. Any pointers / suggestions will help. thanks. Nars
That's pretty cool objects in SQL Server 2017, thanks for letting me know that. 🙂
So I understand the graph objects based on below picture from Graph Data Processing with SQL Server 2017.
According to the data structure, those two visuals Network Navigator and Force-Directed Graph seem optional to show the structure.
Thank you for the recommendations. I will try it out. Do you know how to incorporate ASCII-ART syntax in PowerBI? How does powerbi work with node tables and edge tables?
select m.memberid as parent,
c.MemberID as child, RelSide
from members m, relationship p, members c
WHERE MATCH(m-(p)->c)
and m.memberid = 10
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |