Tables to list roles and users

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello everybody.

I'm using a connection to Dynamics 365: https://xxxxxxx.api.crm2.dynamics.com/api/data/v8.2/ to make a report.

From Power BI I need to show in a report a complete list of all the users and the roles that they have assigned in the different organizational units, however, NOT all the users and their roles are listed (they should be shown in the systemuserrolescollection table) in the business units created. Although, the CRM has a report (by default) where the users and their roles are listed, the *.rdl lists the [systemuserroles] table, but when trying to read it from the Power BI, the table is not listed:

I use these tables: roles, systemuserrolescollection and systemusers:

Thanks for your help!

*This post is locked for comments