Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
gjfbarbosa2
New Member

Model View - "All Tables" diagram totally messed

Has anyone ever seen PBI move some of the tables in the "All Tables" diagram to a place many screens (really many, I didn't count) below the main group of tables?

I know that I can build another diagram and  correct theproblem. I've done it and they work perfectly.

However, the main digaram went totally crazy, and moving the tables back to their place manually does not work.
Any one knows if there is a way to reset this diagram?  

Thank you for any advice!

1 ACCEPTED SOLUTION
Elena_Kalina
Solution Specialist
Solution Specialist

Hi @gjfbarbosa2 

  1. Create a new diagram:

    • In Model View, click the New Diagram icon (looks like a blank page)

    • Name it "All Tables Reset" or similar

  2. Add all tables to the new diagram:

    • Right-click in the blank diagram area

    • Select Add All Tables

    • Alternatively, drag tables manually from the fields pane

  3. Apply Auto Layout:

    • Select all tables (Ctrl+A)

    • Right-click any table → Arrange Tables  Auto Layout

    • Wait for Power BI to reorganize everything

  4. Set as default view (optional):

    • Right-click the new diagram → Set as Default Layout

    • This makes it the view that opens by default

Alternative Nuclear Option

If the above doesn't work, try this more thorough reset:

  1. Close Power BI Desktop

  2. Navigate to your file location and make a backup copy

  3. Rename the .pbix file to .zip

  4. Open the zip and navigate to \Layouts\

  5. Delete Model.layout (this contains the corrupted layout)

  6. Rename back to .pbix and reopen

Prevention Tips

To avoid this issue recurring:

  • Use multiple diagrams for logical subject areas

  • Save frequently during manual arrangement

  • Avoid excessive zooming/panning while editing

  • Consider using external tools like Tabular Editor for large models

Important Notes

  • The "All Tables" diagram is special - it can't be deleted but can be reset

  • Power BI sometimes loses layouts with:

    • Very large models (50+ tables)

    • Complex relationship patterns

    • Multiple monitor setups

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

View solution in original post

2 REPLIES 2
gjfbarbosa2
New Member

Thank you so much! I think I'll go straight to the nuclear option. 😁

Elena_Kalina
Solution Specialist
Solution Specialist

Hi @gjfbarbosa2 

  1. Create a new diagram:

    • In Model View, click the New Diagram icon (looks like a blank page)

    • Name it "All Tables Reset" or similar

  2. Add all tables to the new diagram:

    • Right-click in the blank diagram area

    • Select Add All Tables

    • Alternatively, drag tables manually from the fields pane

  3. Apply Auto Layout:

    • Select all tables (Ctrl+A)

    • Right-click any table → Arrange Tables  Auto Layout

    • Wait for Power BI to reorganize everything

  4. Set as default view (optional):

    • Right-click the new diagram → Set as Default Layout

    • This makes it the view that opens by default

Alternative Nuclear Option

If the above doesn't work, try this more thorough reset:

  1. Close Power BI Desktop

  2. Navigate to your file location and make a backup copy

  3. Rename the .pbix file to .zip

  4. Open the zip and navigate to \Layouts\

  5. Delete Model.layout (this contains the corrupted layout)

  6. Rename back to .pbix and reopen

Prevention Tips

To avoid this issue recurring:

  • Use multiple diagrams for logical subject areas

  • Save frequently during manual arrangement

  • Avoid excessive zooming/panning while editing

  • Consider using external tools like Tabular Editor for large models

Important Notes

  • The "All Tables" diagram is special - it can't be deleted but can be reset

  • Power BI sometimes loses layouts with:

    • Very large models (50+ tables)

    • Complex relationship patterns

    • Multiple monitor setups

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.