Power Query Access Matrix Viewer

Problem

Raw access exports are often difficult for business users to read, making it harder to understand who has access to folders, reports, or security groups.

Approach

Used Power Query to reshape, clean, group, and pivot access data into a readable matrix focused on folders, groups, and permission levels.

Impact

• ✓Improved access review readability
• ✓Reduced manual cleanup effort
• ✓Made permission patterns easier to understand
• ✓Created a more audit-friendly view of access