Forum Discussion
Systemuser table mutiple relationships
I'm using 2016 update 1 CRM Online with Power BI connected via HTTP REST API to boost speed. I'm using the 'best practice' protocol of not using expanded columns in the data query but rather usin...
I believe that one way to solve this would be to download the Systemuser table 3 times. I would name the tables "Owner Users", "Create Users" and "Modify Users" or something similar to tell them apart from one another. Relate each of the columns in the entity table to its corresponding Systemuser table. Then you can use the column from each of the 3 tables in the same visualization.
