SQL server or PowerBI to create table relationship

[Anonymous]

Hi All,

What is the optimal solution for creating relationship between tables as per below details.

1) I am using SQL Server 2018 and Power BI Pro

2) 20 Tables (15 small tables , 5 heavy tables) exist in SQL having approx. 7 million records

3) To create reports, I need to make relationship between tables

Should I create relationship in SQL (Database Diagram ) OR in Powerquery using Import data functionality ?

I have created some relationship in PowerBI, Is there a possibility to import the same relationship in SQL Database Diagram ?

Thanks in advance. 

[Tahreem24]

Hi @Anonymous , 

You need to create a relationship between all those in Power BI desktop under Relationship View.

Please give Thumbs up for support and accept this as a solution if it helps you!

[Anonymous]

Hi @Tahreem24 ,

Thanks for your quick reponse.

Does this mean IMPORT functionality will be used and NOT Directquery ? 

[Tahreem24 · Accepted solution]

@Anonymous ,

You can create relationship in both the modes(Import and Direct Query).

KUDOS would be really appreciated! Also mark this as a solution if it helps you!