web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Power BI report on roles permissionsets and authorisation

(0) ShareShare
ReportReport
Posted on by
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?
 
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 83 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 68

#3
Martin Dráb Profile Picture

Martin Dráb 60 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans