This pane is where much of the work of the Query view is accomplished. In the center pane, or Data pane, data from the selected query is displayed. The following image shows the left pane with a query. When you select a query from the left pane, its data is displayed in the center pane, where you can shape and transform the data to meet your needs. The left pane, or Queries pane, displays the number of active queries and the name of the query. It's useful to know that many of the tasks available from the ribbon are also available by right-clicking a column, or other data, in the center pane. It's also used to display the Advanced Editor.
Manual del redactor windows#
The View tab on the ribbon is used to toggle whether certain panes or windows are displayed. The following image shows the Add Column tab. The Add Column tab provides additional tasks associated with adding a column, formatting column data, and adding custom columns.
The Transform tab provides access to common data transformation tasks, such as:įor more information about transforming data, including examples, see Tutorial: Shape and combine data in Power BI Desktop. For information about connecting to data, including examples and steps, see Connect to Data. A menu appears, providing the most common data sources.įor more information about available data sources, see Data Sources. To connect to data and begin the query building process, select New Source. The Home tab contains the common query tasks. The ribbon in Power Query Editor consists of four tabs: Home, Transform, Add Column, View, Tools, and Help. We'll look at each of these four areas: the ribbon, the Queries pane, the Data view, and the Query Settings pane. The Query Settings pane appears, listing the query's properties and applied steps. In the center pane, data from the selected query is displayed and available for shaping. In the left pane, queries are listed and available for selection, viewing, and shaping. In the ribbon, many buttons are now active to interact with the data in the query. Here's how Power Query Editor appears once a data connection is established: If we connect to the following Web data source, Power Query Editor loads information about the data, which you can then begin to shape: Once a query is loaded, Power Query Editor view becomes more interesting. With no data connections, Power Query Editor appears as a blank pane, ready for data. To get to Power Query Editor, select Transform data from the Home tab of Power BI Desktop.
Manual del redactor how to#
You'll also find guidance about connecting to data, shaping data, creating relationships, and how to get started.īut first, let's see get acquainted with Power Query Editor. At the end of this document, you'll find links to detailed guidance about supported data types.
This document provides an overview of the work with data in the Power Query Editor, but there's more to learn. Use Power Query Editor to connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop. Power BI Desktop also comes with Power Query Editor.
In the following image, Report view is selected, indicated by the yellow band beside the icon.
With Power BI Desktop you can connect to the world of data, create compelling and foundational reports, and share your efforts with others – who can then build on your work, and expand their business intelligence efforts.
0 kommentar(er)
