Power BI Desktop 中的数据视图Data View in Power BI Desktop

数据视图有助于你检查、浏览和了解 Power BI Desktop 模型中的数据。Data View helps you inspect, explore, and understand data in your Power BI Desktop model. 它与你在查询编辑器中查看表、列和数据的方式不同。It's different from how you view tables, columns, and data in Query Editor. 在数据视图中,你所看到的数据是在将其加载到模型之后的样子。With Data View, you’re looking at your data after it has been loaded into the model.

建模数据时,有时想要在报表画布上未创建视觉对象的情况下,查看表或列中的实际内容,通常会查看到行级别。When you’re modeling your data, sometimes you want to see what’s actually in a table or column without creating a visual on the report canvas, often right down to the row level. 特别是当你要创建度量值和计算列时,或者需要识别数据类型或数据类别时。This is especially true when you’re creating measures and calculated columns, or you need to identify a data type or data category.

让我们仔细了解下。Let’s take a closer look.

1.数据视图图标 – 单击可进入数据视图。1. Data View icon – Click to enter Data View.

2.数据网格 – 显示选中的表以及其中的所有列和行。2. Data Grid – Shows the selected table and all columns and rows in it. 报表视图中的隐藏列显示为灰色。右键单击列可获取相关选项。Columns hidden from Report View are greyed out. You can right-click on a column for options.

3.建模功能区 – 管理关系、创建计算、更改列的数据类型、格式、数据类别。3. Modeling ribbon – Manage relationships, create calculations, change data type, format, data category for a column.

4.公式栏 – 输入度量值和计算列的 DAX 公式。4. Formula bar – Enter DAX formulas for Measures and Calculated columns.

5.搜索 - 在模型中搜索表或列。5. Search – Search for a table or column in your model.

6.字段列表 – 选择要在数据网格中查看的表或列。6. Fields list – Select a table or column to view in the data grid.