Power BI Interface Overview
Power BI · Power BI Introduction
Theory
Power BI Desktop has a ribbon on top, a set of views on the left and panes on the right. Report view is the canvas where you place visuals. Table view (called Data view in older versions) shows the loaded rows of each table so you can check values and create calculated columns. Model view shows tables as boxes with relationship lines between them. DAX query view lets you write and run DAX queries against the model, and TMDL view shows the semantic model as a script you can edit and apply.
On the right in Report view sit the Visualizations pane (pick a visual and drop fields into its wells), the Data pane (called Fields in older versions, listing tables, columns and measures) and the Filters pane (visual, page and report-level filters). For example, to chart sales by region you click the bar chart icon, drag Region to the Y-axis well and [Total Sales] to the X-axis well.
Why we use it
Knowing where each tool lives saves a lot of time and makes tutorials easy to follow. Most beginner confusion, such as 'where do I create a relationship?', is just not knowing which view to open.
When to use it
Use Report view to design, Table view to verify data and calculated columns, and Model view for relationships, hiding fields and properties. Use the Power Query Editor (Home → Transform data), not Table view, when you need to change the data itself.
How it works
- Open Power BI Desktop
- Load data with Home → Get data
- Need to fix or reshape the data? Yes: Open Power Query via Transform data. No: Go straight to Model view.
- Create relationships in Model view
- Write measures and build visuals in Report view
- Save the .pbix file
Syntax
Left rail: Report | Table | Model | DAX query | TMDL views
Right panes (Report view): Visualizations | Data | Filters
Ribbon: Home → Get data / Transform data / New measure / PublishExample
1. Report view: click Clustered bar chart in the Visualizations pane.
2. Data pane: drag Sales[Region] to Y-axis and [Total Sales] to X-axis.
3. Filters pane: add Products[Category] = "Electronics" as a page filter.
4. Table view: open Sales and confirm Amount is a whole number.
5. Model view: check the one-to-many line from Customers to Sales.Key points
- Report view is where you build visuals on the canvas
- Table view lets you inspect loaded rows and calculated columns
- Model view is where you define relationships between tables
- Filters pane has visual, page and report scopes
- Changing source data belongs in Power Query, not Table view
- DAX query view and TMDL view let you query and script the model as code