Sharing my tool "Page Switcher" for editing Power Bi Report Pages

Hi everyone,

I wanted to share with the community a project of mine that I am very passionate about:
Release Power BI Page Switcher 1.0.6 · Parreirao2/Power-BI-Tools (github.com)

This tool is a Python script I created that provides a graphical user interface (GUI) to easily edit the pages within a Power BI report (.pbix) file. You can change page names, ordinal values, page visibility and type, size dimensions, search for used measures/columns/tables per visual, and even duplicate or delete pages with just a few clicks.
I hope someone out there finds it useful! :)

How to Use:

  1. Open the Application: Run the app to open the Page Switcher GUI.
  2. Select PBIX File: Click the "Select PBIX File" button to choose the Power BI file you want to edit. (A new .zip file will be created in your folder; do not delete or alter this file, as it is the converted .pbix file the script reads its JSON files from.)
  3. Edit Page: Double-click on a page in the list to edit its ordinal value and name in the pop-up window. You can also change the Width and Height of the page, set it to hidden or unhidden, and even choose the page type.
  4. Search Box: Type the name of the Table, Measure, or Column, and the app will display only the pages and visuals containing these fields.
  5. Delete Page: Check the box next to the page(s) you want to delete and click the "Delete" button at the bottom.
  6. Duplicate Page: Check the box next to the page(s) you want to duplicate and click the "Duplicate" button at the bottom. (New pages will have the highest ordinal value available, meaning they will always go to the bottom of the list.)
  7. Save Changes: Click the "Save Changes" button to save your edits. A new PBIX file will be created with '_ChangedOrdinality.pbix' appended to the original file name. (A new file is created to prevent possible losses. You can open this new PBIX file to verify the changes and save over the original file if you're satisfied.)

Important Notes:

  • Ensure the new PBIX file is not open when saving changes.
  • Always keep backups of your original PBIX files before making any edits.

I hope you find this tool useful! Feel free to ask any questions or provide feedback.

Happy reporting!

When you select a PBIX File

You can see for each page the visuals and Columns/Measures used on each one (still alpha an feature)

You can edit the Ordinal (page position), name, width, height, set it to hidden or unhidden, and change the page type

You can duplicate or delete pages in bulk.