Database Reference
In-Depth Information
Viewing the Advanced Editor
Power Query lets you view and edit your query's embedded M code directly. While in the Query
Editor window, click the Advanced Editor button on the View tab. The Advanced Editor window
opens, as shown in Figure 7-10.
Figure 7-10: The Advanced Editor window.
The Advanced Editor window is little more than a space for you to type your own M code. The M lan-
guage is a fairly robust one, allowing for many advanced actions that you can't take through the
Query Editor. You can directly code your own steps.
If you're interested in learning more about M language and coding your own steps, start
with the M Language specification guide by Microsoft. To get it, type Microsoft Power
Query Formula Language Specification into your favorite search engine.
Note
Outputting your query results
When you've configured your Power Query data, you can output the results. This would be the load
part of ETL. At the bottom of the Query Settings pane (see Figure 7-11), choose how you want to
output your data:
Load to Worksheet: This is the default choice. It outputs the results as a table in a workbook.
Load to Data Model: This choice outputs the data to the internal Data Model that you can
integrate into a Power Pivot report.
Then click the Home tab and click the Apply & Close button. At this point, the Query Editor window
closes, and depending on the location you have chosen, your results are loaded to either an Excel
table in the current workbook or the internal Data Model.
 
Search WWH ::




Custom Search