CData Power BI Connector for AWS Data Management 2019 - Online Help
Questions / Feedback?

Getting Data

CData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362

After Installing the Connector and Creating the Data Source Name, you can connect to the data that you want to work with. After connecting to the data, you can edit or load the data to start building reports.

Connect to the Data

Complete the following steps to connect to the data:

  1. Click Get Data.
  2. Accept the warning to connect to a third-party service.
  3. Select All > CData AWS Data Management in the Data Source Name menu.
  4. Select Connect.
  5. Enter the Data Source Name, Advanced Connection Properties (optional), and Advanced Options (optional).
    • Note that the default Data Source Name is CData Power BI AWSDataManagement, but you can change this name by editing the DSN configuration. See Creating the Data Source Name for more information.
    • See Querying Data for more information on the optional fields.
  6. Select a data connectivity mode and click OK. See Querying Data for more information on each mode.
    • Select Import to import a copy of the data into your project. You can refresh this data on demand.
    • Select DirectQuery to work with the remote data.
  7. In the Navigator window, expand the CData Power BI AWSDataManagement folder, then expand the associated schema folder to see a list of available data (tables, stored procedures, or views).
  8. Select the box next to the data that you want to work with.
  9. Select Load or Edit. See the next section for more information on these options.

Load or Edit the Data

After connecting to the data, load or edit the data, as described below.

  • When you click Load, the connector executes the underlying query to AWSDataManagement.
  • When you click Edit, the Query Editor launches and a representative view of the table is presented. You can use the Query Editor to adjust the query and query results before you load the data. Right-click a column header to perform actions like the following:
    • Rename columns or tables
    • Change text to numbers
    • Remove rows
    • Set the first row as headers

Next Step

After getting the data, you can create visuals and reports. See Visualizing Data for more information.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7362.0