Get Data

Start by importing tables and views from a Line of Business database, which will serve as the base data for our data model and visualisations.

  1. Go to Home tab > Click on Get Data > Select More… GetData

  2. Go to Azure > Select Azure SQL Database > Click Connect. Azure SQL Database

  3. Enter the following details, then click OK:

    • Server: bdtraining.database.windows.net
    • Database: WideWorldImporters
    • Data Connectivity mode: Import ConnectString

  4. Enter the details below, and then click Connect. Make sure you have selected Database, not Windows credentials

    • Username: student
    • Password: P0werB1Training! DatabaseCredentials

  5. Tick the following database tables on your left, then click Load

    • Application.vwCities
    • Sales.vwCustomers
    • Sales.vwOrderDetails
    • Warehouse.vwStockItems
    • Application.Countries SelectTables

We are now going to import an existing date table from the data warehouse.

  1. Click on Get Data > Select More… > Click on Azure > Select Azure SQL database

  2. Enter server details:

    • Server: bdtraining.database.windows.net
    • Database: WideWorldImportersDW
    • Data Connectivity mode: Import Connect String

  3. Select Dimension.Date from the WideWorldImportersDW database. Tables

There is a new table called Dimension Date in the FIELDS pane.