Microsoft Power BI Cookbook
上QQ阅读APP看书，第一时间看更新
上一章目录下一章

Getting ready

  1. Build a query through the user interface that connects to the AdventureWorksDW2016CTP3 SQL Server database on the ATLAS server and retrieves the DimGeography table, filtered by United States for English.
  2. Click on Get Data from the Home tab of the ribbon, select SQL Server from the list of database sources, and provide the server and database names.
    • For the Data Connectivity mode, select Import.
Figure 1: The SQL Server Get Data dialog

A navigation window will appear, with the different objects and schemas of the database. Select the DimGeography table from the Navigation window and click on Edit.

  1. In the Query Editor window, select the EnglishCountryRegionName column and then filter on United States from its dropdown.
Figure 2: Filtering for United States only in the Query Editor

At this point, a preview of the filtered table is exposed in the Query Editor and the Query Settings pane displays the previous steps.

Figure 3: The Query Settings pane in the Query Editor
上一章目录下一章