I'm looking to import the table containing the links between permissionsets in Power BI.
I'd like to have this for a Power BI report on roles and authorisation in Business central
I found:
on page: Permission Set Tree (9857, ListPart)
TableData 9861 'Permission Set Relation Buffer'
But I have no acces to it, even with role 'SUPER'
I learned that permissionsets can be connected to:
The application (in order for it to work properly),
The user licence.
To a security group
And to another permissionset.
In my case the permissionset CDC ALL has a set of permissions on objects in Busniess Central and it's linked to:
CDC BASIC
CDC BASIC Documents
both are connected permissionsets and have separate permissions.
For a complete report I'd like to show the net result per user. The sum of all permissions.
Can anyone point me in the right direction?
Is it a system table, only accessable via an export of configuration package?