Grid View

Grid View presents your model as a set of data grids, giving you a spreadsheet-like way to browse and edit tables, columns, measures, relationships, and other model objects.

Switch to Grid View using the toggle in the toolbar.

What You Can See

Each tab in Grid View shows a different category of model objects:

• Tables: All tables in your model with their properties
• Columns: Every column across all tables, with data type, format string, description, and other metadata
• Measures: All measures with their DAX expressions
• Relationships: Every relationship, showing the from/to tables and columns, cardinality, and cross-filter direction
• Roles: Security roles and their filter expressions

Inline Editing

Click any editable cell to modify it directly in the grid. This is especially useful for bulk operations like updating descriptions, changing data types, or adjusting format strings across many columns at once.

Sorting and Filtering

Click column headers to sort by that column. Use the filter row to narrow down the list when working with large models.

When to Use Grid View vs. Diagram View

• Grid View works best for reviewing and editing properties across many objects at once. If you need to update the format string on 30 columns, the grid is much faster than clicking through each one individually.
• Diagram View works best for visual tasks like understanding table relationships, reorganizing your model layout, and getting an overview of the model structure.

You can switch between views at any time. Both views edit the same underlying model.