BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 21 March 2019
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Multiple database diagrams in the new Power BI Model View
You can create different database layouts - no longer do you have to fit everything into one screen!
Here's how this might work. Supposing that you upload all of the tables in a database, and initially get a diagram like this (which Power BI will call All tables):
Initially the diagram is hard to read - there are just too many tables.
You can now show (for example) all of the tables to do with the geographical breakdown of sales in a separate diagram:
Click on the + button to add a new layout.
You can now drag tables onto your diagram:
Here I've dragged the tblRegion and tblTown tables onto my layout, and am in the middle of adding the tblCentre table.
You should end up with a view onto a subset of your tables:
This layout only includes 3 tables.
You can thus create multiple layouts, each focusing on a different aspect of your database, making everything much easier to decipher!