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.
Go to Solution.
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!
View solution in original post
Hi @mridul ,
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!
Hi @Tahreem24 ,
Thanks for your quick reponse.
Does this mean IMPORT functionality will be used and NOT Directquery ?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!