Dynamics 365 Business Central User Report
For purposes of an audit, I'm trying to generate a report of users and their assigned permission sets in the system. For reference, we do not use Security Groups; users are only assigned permission sets directly (so no need to run any other sort of users to groups report).
I know (and I've seen) the native 'Permission Sets by User' view/report - but what I'm finding with this report is it only shows 10 users/columns at a time. I saw you can click 'Browse' and do 'column right' to show more columns (users), but it still limits the view to just 10 at a time. Similarly when you export the report to Excel - it only outputs the 10 visible columns.
Is this really a limitation in BC where you can't just export a full report/view of all users and their permission sets? The format of this 'Permission Set by User' view/report is fine (matrix format) - but needing to generate it for every 10 users is not a sustainable process. Surely there's a reasonable way of going about this (without creating some custom report)??