Here is python script. that i used to export all our roles into a csv files as a matrix
Original Message:
Sent: 10-02-2025 00:41
From: Amit Abdul
Subject: Roles and Permission Comparisons
I would like to export all the roles, etc, so that I have a way to analyze it and ensure that we do not have something unusual. Can you please share with us how to export it using PowerBI or another tool?
------------------------------
Amit Abdul
------------------------------
Original Message:
Sent: 10-01-2025 11:59
From: Daniel Possekel
Subject: Roles and Permission Comparisons
Hi James, I am happy to share this. I'd like to first wait for the new permissions (new UI) to hit our org before I run another update. What exactly are you looking for? Compare orgs, roles or review licenses? These were the use cases I had so far.
------------------------------
Daniel Possekel
Business Analyst
Original Message:
Sent: 10-01-2025 09:05
From: James Terry
Subject: Roles and Permission Comparisons
@Daniel Possekel
Hello, I would like to see your approach in more detail for either Power Bi or Power Query when able.
Thanks!
------------------------------
James Terry
Contact Center Support Engineer 3
Original Message:
Sent: 08-01-2025 02:45
From: Daniel Possekel
Subject: Roles and Permission Comparisons
Hi Amit, I had the same demand and build myself a comparison in Power BI within one stage using Power Query. If you are not familiar with Power BI as such, Power Query is also part of Excel. I used it to unfold the JSON structure of the API Explorer output. Extending it to compare across two exports shouldn't be much of an extension of the logic.
If this could be an option, just let me know - I am happy to share my approach in more detail, if it helps.
------------------------------
Daniel Possekel
Business Analyst