A Power BI tenant settings audit sounds like a small admin job until someone exports half the finance model to an unmanaged spreadsheet. Power BI and Microsoft Fabric tenant settings give admins fine-grained control over which features are available. Microsoft is clear about the caveat, though: tenant settings help set governance policy, but they don’t replace permission design, semantic model security, sensitivity labels and good operational process.
This guide turns the admin portal into an operating checklist. The goal isn’t to lock every button down. It’s to decide which capabilities are open to everyone, which are limited to approved security groups, and which need evidence before they go near production.
Why a Power BI tenant settings audit matters
Fabric tenant settings control sharing, export, publishing, workspace behavior, audit and usage features, integrations, AI experiences, developer options and more. Microsoft’s tenant settings index changes over time, and the admin portal can flag new or changed settings. A review done at rollout may already be out of date.
Any setting that touches export, external sharing, tenant-wide publishing, public links, custom visuals, service principals or Copilot and AI behavior deserves a named owner.
Audit in four passes
Sharing, publish to web, external guests, exports
Security groups, workspace roles, domains, approvals
Audit logs, usage metrics, admin APIs, reviews
Setting owner, exception process, review cadence
The 10 guardrails
1. Start from the tenant settings index, not memory
The tenant settings index is the source of truth. Record your decisions in a simple register: setting name, current value, allowed group, business owner, risk note and next review date. Give new, unknown or “temporarily enabled” settings a real review.
2. Use security groups for controlled enablement
Many settings can be enabled for the whole organization, specific security groups, or with exclusions. Prefer named groups over individuals. A group such as PowerBI-Allowed-Export-Data is searchable and auditable.
3. Separate UI controls from real data security
Microsoft notes that tenant settings controlling UI features aren’t a security boundary. Hiding an export button doesn’t remove a user’s read permission on a semantic model. Treat tenant settings as guardrails, and enforce access with workspace roles, model permissions, row-level security, sensitivity labels and DLP.
| Control | Helps with | Doesn’t replace |
|---|---|---|
| Tenant setting | Feature availability and policy | Model permissions or data classification |
| Workspace role | Collaboration permissions | Dataset-level business rules |
| Row-level security | User-specific data filtering | Tenant-wide feature governance |
4. Review export and sharing settings first
Export, download, publish and sharing controls are the fastest path from a governed report to an unmanaged file. Start with exporting data, downloading reports, external sharing, publish to web, embedding and email subscriptions. Decide what is tenant-wide, what is group-scoped and what needs an approved exception.
5. Govern workspace creation without blocking it
Problems start when every proof of concept becomes a semi-production workspace with no owner. Use a naming standard, a required owner group, lifecycle reviews and a clear split between personal experiments, departmental BI and certified enterprise content.
| Before: ungoverned | After: governed self-service |
|---|---|
| No naming pattern | Purpose-based names |
| Individual owners | Owner security group |
| Unknown sensitivity | Domain or business area assigned |
| No stale-content review | Quarterly review |
6. Turn audit and usage data into a habit
Enabling telemetry isn’t enough. Decide what you review monthly: risky sharing, abandoned workspaces, unusual exports, gateway failures, heavily used reports without owners, and certified datasets nobody uses.
7. Decide how domains fit your model
Fabric domains organize data by business area and support federated governance. If you have strong departments or data product owners, plan domain owners, contributor groups, naming, endorsement rules and what stays central before you create them.
8. Roll out AI and preview features deliberately
The tenant settings index includes newer AI-related controls. Pilot them with a group that understands data sensitivity and acceptable use. Small, measured and documented beats turning everything on.
9. Document exceptions like production changes
Exceptions are normal; invisible ones are the problem. Record the requester, setting, scope, justification, expiry date and rollback owner. An exception without an expiry date is really a policy.
10. Re-audit when Microsoft changes the settings
Scan for new settings monthly, review high-risk settings quarterly, and review immediately after major Fabric or Power BI releases. Keep the register short enough that people actually maintain it.
Power BI tenant settings audit register
| Field | Example |
|---|---|
| Setting name | Export data |
| Current state | Enabled for approved creators group |
| Business owner | Data governance lead |
| Risk note | Sensitive data may leave managed reports |
| Review cadence | Quarterly, plus after major Fabric updates |
| Exception path | Ticket, expiry date and manager approval |
Prioritize the risky settings
| Risk area | Impact | Admin move |
|---|---|---|
| Export and download | Data leaves the managed experience | Scope to approved groups |
| External sharing | Content crosses the tenant boundary | Require owner and review |
| Workspace sprawl | Unknown ownership | Naming and lifecycle policy |
| Telemetry gaps | Admins can’t see activity | Enable audit and usage review |
A default policy pattern
- Default open: low-risk productivity features that don’t expose data broadly.
- Default scoped: export, external sharing, publish to web, service principals, custom visuals and developer features.
- Disabled until reviewed: features with unclear data movement, broad exposure or unassessed preview behavior.
- Always documented: exceptions, owner groups, rationale and review dates.
Bottom line
A Power BI tenant settings audit gives makers a safer runway, admins fewer surprises, and leadership confidence that self-service analytics is under control. Govern the risky settings, automate the reminders, and leave room for people to build useful reports. The same thinking applies across the platform; see our Managed Environments guide and Power Platform DLP policies.
Last reviewed: October 2026
Sources
- About tenant settings in Microsoft Fabric (Microsoft Learn)
- Fabric tenant settings index (Microsoft Learn)
- Audit and usage admin settings (Microsoft Learn)
- Workspaces in Power BI (Microsoft Learn)
- Microsoft Fabric adoption roadmap: governance (Microsoft Learn)
- Domains in Microsoft Fabric (Microsoft Learn)
Discover more from Cloud Osprey
Subscribe to get the latest posts sent to your email.