Forum Discussion
Ambiguity error while creating relationship s
Hi All,
I have four tables. The data source in MS Dynamics CRM
1.Phonecalls - contains phone calls created data
2.Accounts - All accounts information
3.Contacts - contacts data
4.Leads - Leads created data
I want to create common date filter across all the tables for finding phone calls made,leads created, accounts created, contacts created etc with respective records for each. So I created a calendar table and tried creating relationship with all the tables from calendar table but it gave ambiguity relationship error. I have even tried by creating reference table for each of them but still the ambiguity error comes up.
Please help me out with any suggestions to get above mentioned common date filtering across multiple tables
I have four tables. The data source in MS Dynamics CRM
1.Phonecalls - contains phone calls created data
2.Accounts - All accounts information
3.Contacts - contacts data
4.Leads - Leads created data
I want to create common date filter across all the tables for finding phone calls made,leads created, accounts created, contacts created etc with respective records for each. So I created a calendar table and tried creating relationship with all the tables from calendar table but it gave ambiguity relationship error. I have even tried by creating reference table for each of them but still the ambiguity error comes up.
Please help me out with any suggestions to get above mentioned common date filtering across multiple tables
1 Reply
I suggest you read this:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!Stay up to date on
Read my blogs onRemember to spread knowledge in the community when you can!
