Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
For purposes of simplicity, imagine you have these four tables:
Sales
Credit Memos
Dates (Lookup table)
Customer Accounts (Lookup table)
Sales records a customers id, sales amount, with an invoice date.
Credit memos records a customers id, return amount, and a paid date.
I want to attach both the Sales and Credit Memos table to both the Dates and Accounts tables (which are lookup tables), but when I try to create the relationships, its telling me it creates ambiguity between the dates and accounts tables.
What I want:
Sales Table connected to dates table on invoice date, and connected to Customer Accounts table on Account_ID
Credit Memos table connected to dates table on paid date, and connected to customer accounts table on Account_ID
How do I do this properly?
It sounds like you have multiple fact tables which make modeling a bit more complex! You can do it, I'd suggest checking out this video:https://www.youtube.com/watch?v=TnyRsO4NJPc
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |