I'm trying to use the Dataverse connector to create a Power BI report with users, their security roles, teams and the applications that are shared with them (either shared with a Team or shared with Individuals directly). I would like to create one report view that includes all situations that you can have in an environment, such as:
1) The User belongs to a Team or not ( an Owner Team or a Groups Team)
2) A Canvas App or a Model Driven App
3) The app is in a Solution or is not in a Solution
4) Security Roles are assigned to Teams or directly to individual Users
What I'm really asking is what is the best way to create the data model for the report that takes all of the relationships into consideration. The report itself will be very simple:
Canvas App A | Solution A | Team A | Security Role A | User A (App is shared through Team A in this Case and Security Role is associated with Team A or User A directly)
Canvas App A | Solution A | (blank) | Security Role B | User B (App is shared directly in this case and Security Role B is assigned directly to User B as User B does not belong to a Team)
Canvas App B | (blank) | Team B | Security Role B | User C (App is not in a Solution and app is shared through Team B with User C who has Security Role B assigned either directly or through Team B)
Model-Driven App C | Solution C | Team C | (blank) | User C (App in Solution C share with User C through Team C; however no Security Role has been assigned to either Team or User)
etc.
etc.
