Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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!
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!
Hi @Tahreem24 ,
Thanks for your quick reponse.
Does this mean IMPORT functionality will be used and NOT Directquery ?
@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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |