cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
narsiman
New Member

Working with SQLGraph - SQL Server 2017

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

3 REPLIES 3
narsiman
New Member

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


@narsiman

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.

Figure-2_thumb

 

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

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors