Forum Discussion
Relationships between tables from CRM Dynamics 365
Hello,
I'm having a hard time with relationships between tables that I imported using dataverse to connect with the CRM Dynamics 365.
I have the account table and opportunity and I linked them with the Account id and the relationship doesn't work.
I even exported the data in Excel and did a Vlook up with the account id and I have more than 1800 matches.
Here is an example of the Vlook up.
| Account (account table) | Account Name (account table) | accountid (opportunity table) |
| 45C3EBB9-BAA9-EB11-B1AC-000D3A5B8403 | 1.2.3. Santé | 1.2.3. Santé |
| 5D12B0A4-A939-ED11-9DB0-002248082F97 | 11555952 Canada Inc | 11555952 Canada Inc |
| FF13250C-6FC8-EA11-A812-000D3A3479C5 | 3845 Aliments Québec Express | 3845 Aliments Québec Express |
| BDBBB97C-9441-EC11-8C60-000D3A35A24E | 3PL Links Inc | 3PL Links Inc |
| BF52575C-363F-ED11-9DB1-002248082F97 | 4412532 Canada Inc | 4412532 Canada Inc |
So how come it doesn't work in BI? What am I missing? Here is a screen shot of my tables in BI
I tried changing the properties and everytime I get an error message.
Cat_Car It looks like your relationship is inactive which is probably because you have a different active relationship path between those two tables. You can use USERELATIONSHIP in a CALCULATE statement to activate an inactive relationship within a particular measure calculation.
2 Replies
Greg_Deckler Thank you very much. I hadn't paid attention that some relationships were inactive.
Thanks!
- Greg_Deckler
Community Champion
Cat_Car It looks like your relationship is inactive which is probably because you have a different active relationship path between those two tables. You can use USERELATIONSHIP in a CALCULATE statement to activate an inactive relationship within a particular measure calculation.
