Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SQL server or PowerBI to create table relationship

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. 

 

  

 

 

Need Help
Tips and Tricks
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    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!

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Tahreem24 ,

       

      Thanks for your quick reponse.

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

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        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!