Skip to main content

How to Switch Between Viewing and Editing a Power BI Report

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

A saved Power BI report opens in Viewing mode, the way readers see it. To change it, switch to Editing. Here's how, and what changes on screen.

Microsoft's Use Report view in the Power BI service describes the two modes: Viewing mode provides commands for interacting with a report without changing its design, and Editing mode provides commands for creating and changing it. The same article says the new ribbon, Try the new ribbon (preview), is available only after you save a report. The example is Expenses Report, a saved report of expense claims.

Prerequisites​

  • The Contributor role or higher in the workspace. Microsoft's report editor tour says that to open a report in Editing view, you must be a report owner or creator, or have at least a Contributor role in the workspace.

Step 1: Find the Mode Menu​

Open the report. At the top right, next to Comments and Share, a button shows the current mode, Viewing. The ribbon has only File, Home and View, with reader commands such as Subscribe, Explore and Analyze in Excel:

The saved report in Viewing mode with Try the new ribbon (preview) On, the Viewing button outlined in red next to Comments and Share, a Home ribbon with Subscribe, Alerts and monitoring, Explore, Analyze in Excel, Embed in PowerPoint and PDF, and the report's cards and slicer

Step 2: Choose Editing​

Select Viewing. The menu offers Editing, Make any changes, and Viewing, View, but make no changes. Select Editing:

The mode menu open under the Viewing button, with Editing, Make any changes, outlined in red, and Viewing, View, but make no changes

Step 3: Check the Editing Tools​

The button reads Editing. The ribbon gains the Insert, Design and Optimize tabs, and its Home tab has Save, New page, New visual, Text box and more. The Filters, Visualizations and Data panes appear on the right:

The report in Editing mode with the Editing button, a Home ribbon with Save, Undo, Clipboard, New page, New visual, More visuals, Text box, Arrange, Refresh visuals, View semantic model, Explore, Analyze in Excel and Manage permissions, and the Filters, Visualizations and Data panes on the right

To stop editing, select Editing and choose Viewing. Save your changes first (How to Save a Report in Power BI in the Browser).

Common Mistakes​

MistakeWhat happensDo this instead
Looking for the Visualizations pane in ViewingIt isn't thereSwitch to Editing
Leaving Editing without savingChanges can be lostSave first
Expecting Viewers to editThey can only viewGive editors Contributor or higher

Troubleshooting​

SymptomLikely causeFix
No mode menuYour workspace role is ViewerAsk for Contributor or higher
A different ribbon from the picturesTry the new ribbon (preview) is off, or the report isn't saved yetTurn it on, or save the report

FAQ​

What's the new ribbon?​

The ribbon in the pictures, which brings many Power BI Desktop commands to the web. The article says it's a preview, available only after a report is saved, and that turning it off returns the previous experience.

Does Viewing mode stop filters and slicers?​

No. Readers can still use slicers and filters in Viewing mode; they just can't change the design.

Conclusion​

Select the mode button at the top right and choose Editing to change the report, or Viewing to see it as readers do. The example's Expenses Report opened in Viewing after its first save.

Additional Resources​