API Data Provider - Online Help

Using the Profile in PowerBI

This section provides a walk-through for accessing data from the profile in PowerBI.

Editing the DSN Configuration

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process. Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Specify the required configuration setting to connect to your profile
    • Profile
    • ProfileSettings
  6. Edit any additional configuration settings on the Connection tab and click OK.

Getting Data

After Installing the Connector and Creating the Data Source Name, you can connect to the data that you want to work with. 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 > CDataAPI in the Data Source Name menu.
  4. Select Connect.
  5. Enter the Data Source Name, Advanced Connection Properties (optional), and Advanced Options (optional).
  6. Select a data connectivity mode and click OK.
    • 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 API 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.

After getting the data, you can create visuals and reports

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7711.0