# Roles in Fabric Plan

Planning roles or personas provide control over the operations that users can perform on planning sheets. Roles are flexible and assigned dynamically based on user actions. For instance, if a *viewer* enters a comment, their persona will automatically be upgraded to *stakeholder*. Roles adapt in real time based on how users contribute, without requiring manual role reassignment.

* A **Planner** acts as an author and modeler with administrative privileges and can create planning input structures.
* A **Stakeholder** can collaborate on plans by entering data and writing back values. Stakeholders cannot permanently modify the structure of planning sheets, but they can hide measures or rows and adjust the layout for analysis. These changes are temporary, are not saved, and are not visible to other users.
* A **Viewer** is a consumer with read-only access.  

### Check the current planning role

The role assigned is displayed at the top of the planning sheet. A session is created when a user performs a planning operation, such as opening a planning sheet. Each session has a fixed duration. If a planning action triggers an upgrade to a higher role, the system creates a new session for the upgraded role.

Select the role to view more information, such as session validity or upgrade options.

<figure><img src="/files/KL7uBv1M3kjneiLxO2aU" alt=""><figcaption></figcaption></figure>

When a planning operation triggers a role change, the system displays an upgrade notification before applying the new role.

<figure><img src="/files/mpuGxRsVAKZi0rMONrf6" alt=""><figcaption></figcaption></figure>

### Fabric planning roles

#### Formatting and layout

<table data-header-hidden="false" data-header-sticky data-first-column-sticky><thead><tr><th width="366.272705078125">Capability</th><th width="125.1817626953125">Planner</th><th width="133.1817626953125">Stakeholder</th><th width="113.818115234375">Viewer</th></tr></thead><tbody><tr><td>Change the layout.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Sort, search, filter, rank, and bookmark planning sheets.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Enable totals and subtotals.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Number formatting - convert to percentage, change scaling, adjust decimal places.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Change the font style.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Change value alignment in cells.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Enable ruler</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Configure conditional formatting.</td><td>✅</td><td></td><td></td></tr><tr><td>Apply semantic formatting.</td><td>✅</td><td></td><td></td></tr><tr><td>Undo/redo and reset formats, values, notes, header order, and row order.</td><td>✅</td><td></td><td></td></tr><tr><td>Pivot data.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Add language translations.</td><td>✅</td><td></td><td></td></tr><tr><td>Add page breaks and enable row hilighlights, gridlines, and table outline.</td><td>✅</td><td></td><td></td></tr></tbody></table>

#### Data input, forecasting, and what-if analysis

<table data-first-column-sticky><thead><tr><th width="366.272705078125">Capability</th><th width="123.8182373046875">Planner</th><th width="130">Stakeholder</th><th width="116.0908203125">Viewer</th></tr></thead><tbody><tr><td>Insert rows.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Insert calculated and data input columns.</td><td>✅</td><td></td><td></td></tr><tr><td>Enter values and distribute them to lower levels in the dimensional hierarchy.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Bulk edit values.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Extend time for data input fields.</td><td>✅</td><td></td><td></td></tr><tr><td>Create and manage forecasts.</td><td>✅</td><td></td><td></td></tr><tr><td>Close periods, reforecast, and distribute deficits.</td><td>✅</td><td></td><td></td></tr><tr><td>Insert simulation measures.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Create scenarios, update settings, copy to base, bulk edit, select input method, pivot.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Compare scenarios.</td><td>✅</td><td>✅</td><td>✅</td></tr><tr><td>Use Optimizer.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Use model builder.</td><td>✅</td><td></td><td></td></tr><tr><td>Create locking, distribution, and min/max rules.</td><td>✅</td><td></td><td></td></tr></tbody></table>

#### Writeback and export

<table data-first-column-sticky><thead><tr><th width="366.272705078125">Capability</th><th width="124.72723388671875">Planner</th><th width="130.45458984375">Stakeholder</th><th width="113.8179931640625">Viewer</th><th></th></tr></thead><tbody><tr><td>Export plans to Excel or PDF files.</td><td>✅</td><td>✅</td><td></td><td></td></tr><tr><td>Add and manage destinations.</td><td>✅</td><td></td><td></td><td></td></tr><tr><td>Write back and save planning data.</td><td>✅</td><td>✅</td><td></td><td></td></tr><tr><td>Enable auto-writeback.</td><td>✅</td><td></td><td></td><td></td></tr><tr><td>Select the writeback type, create writeback filters, and rename columns.</td><td>✅</td><td></td><td></td><td></td></tr><tr><td>View Writeback logs.</td><td>✅</td><td>✅</td><td></td><td></td></tr><tr><td>Export Writeback logs.</td><td>✅</td><td></td><td></td><td></td></tr><tr><td>Writeback scenarios and view logs.</td><td>✅</td><td>✅</td><td></td><td></td></tr><tr><td>Add destination to writeback scenarios.</td><td>✅</td><td></td><td></td><td></td></tr></tbody></table>

#### Commenting and collaboration

<table data-first-column-sticky><thead><tr><th width="366.272705078125">Capability</th><th width="125.18182373046875">Planner</th><th width="134.09075927734375">Stakeholder</th><th width="114.7271728515625">Viewer</th></tr></thead><tbody><tr><td>Add notes.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Add and assign comments, tag users, and enable the comments column.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Add report-level comments.</td><td>✅</td><td>✅</td><td></td></tr><tr><td>Edit comments settings.</td><td>✅</td><td></td><td></td></tr><tr><td>Enable the comments pane to view all comments.</td><td>✅</td><td>✅</td><td></td></tr></tbody></table>

#### Build planning models

<table data-first-column-sticky><thead><tr><th width="366.272705078125">Capability</th><th width="125.18182373046875">Planner</th><th width="133.63641357421875">Stakeholder</th><th width="115.63623046875">Viewer</th></tr></thead><tbody><tr><td>Connect the planning workspace directly to enterprise semantic Models in Power BI/Fabric.</td><td>✅</td><td></td><td></td></tr><tr><td>Browse the organizational semantic model catalog(metadata) natively within the planning interface.</td><td>✅</td><td></td><td></td></tr><tr><td>Create Planning, PowerTable, and Intelligence sheets.</td><td>✅</td><td></td><td></td></tr><tr><td>Visualize planning sheets with Intelligence.</td><td>✅</td><td></td><td></td></tr><tr><td>Import and save data from internal sources such as Planning and PowerTable sheets, as well as external sources such as CSV, Excel, JSON, etc.</td><td>✅</td><td>✅</td><td></td></tr></tbody></table>

### Recommended Fabric workspace role mapping

Fabric workspace roles do not restrict planning personas. The following table shows the recommended mapping between Fabric workspace roles and planning personas.

| Planning persona | Fabric workspace role          |
| ---------------- | ------------------------------ |
| Viewer           | Viewer                         |
| Stakeholder      | Viewer                         |
| Planner          | Admin, member, or contributor. |

### FAQs

**Q:** **Can I manually change my role?**                                                                                                         Roles are auto-assigned based on user actions. Roles can be upgraded by selecting the role and selecting the upgrade session button.

**Q: Can roles be downgraded?**                                                                                                                                       N&#x6F;**.** Role changes occur only as upgrades to higher privilege levels. Downgrades are not supported.

**Q:** **Can roles be shared across capacities?**
\
No. Roles are evaluated independently per capacity. Switching capacities can lead to a role change.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/readme/roles-in-fabric-plan.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.