rbac
1 Topic
Configuration Manager RBAC
With the release of Microsoft Endpoint Configuration Manager 2002, Microsoft added support for integrating Power BI into the Configuration Manager console https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/changes/whats-new-in-version-2002#bkmk_report I installed the Power BI Report Server and configured Configuration Manager to use it following this guide. https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/powerbi-report-server Everything works. I can create dashboards and reports querying Configuration Manager views in the SQL database. I want to create a Power BI dashboard that shows statistics of devices, but I only want to show the collections the user has rights to, not all devices/collections. This is easily accomplished in SSRS by enabling RBAC (Role Based Access Control) on the report. The SQL views available in the Configuration Manager database do not support RBAC so instead I need to query Functions. This works when creating SSRS reports, but I cannot for the life of me find out how to do the same thing in Power BI. When creating SSRS Reports, I create a hidden parameter that calls the following code which gets the user's SID, and the SID of any groups they are a member of, from Active Directory: =SrsResources.UserIdentity.GetUserSIDs(User!UserID) How can I call this method on my local Power BI Report Server where the SrsResources.dll is registered? With Microsoft officially supporting Power BI integration with Configuration Manager, configuring RBAC in Power BI should be available. Thanks, ScottSolved5KViews1like3Comments