Forum Discussion

stranter's avatar
stranter
Frequent Visitor
6 years ago

D365 systemuser table

Hi,

 

I'm trying to connect the system user table from D365 to the opportunity, quote and order tables also from D365.

 

I want to connect the owner field with the systemuser table.  How can I connect to one systemuser table, rather than having duplicated systemuser tables for each table.  Here is what I want:

 

 

PBI won't let me activate two of the three relationships between the user table:

 

 

How can I do this?

 

Thanks,

 

Stewart

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Ideally User should be used by Order and Opportunity Via Quote. Rest two relation you can keep inactive. Use them in specific formula (using use relation) when you only need data from these tables.

    • stranter's avatar
      stranter
      Frequent Visitor
      6 years ago
      If I create a slicer with specificusers, it will filter the opportunity, quote and order tables when a specific user is selected?