need help with semantic model permissions

Hi info_algoritmia,

Thank you for reaching out to the Microsoft Fabric Forum Community.

1. Losing “Show data table” after editing auto-generated reports, This is expected behavior. Once you edit or duplicate an auto-generated report, Power BI treats it as a regular report. The special “Show data table” feature is only available in auto-generated reports and is not preserved after manual edits. There is currently no supported way to retain that feature after editing or customizing the report.

2. External users with Read access can still “View semantic model”: Yes, even without Build permission, if the user has read access to the report connected to a dataset in a different workspace, and that dataset is discoverable, Power BI may still allow "View semantic model", though they can’t change or use it. This is by design to allow traceability and transparency. Unfortunately, this view cannot be removed entirely via report or dataset settings alone.

3. To disable semantic model exploration for external users, go to the Power BI Admin Portal (requires admin rights), then navigate to Tenant settings. Under Export and sharing settings, turn off or restrict the following options, “Allow users to view and interact with semantic models in the Data hub”, “Allow semantic model export to Excel”, and “Allow build for external users”. These settings can be scoped to specific security groups to ensure external or guest users are excluded from accessing the semantic model.

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

Thank you & regards,
Prasanna Kumar