Edit

Share via


CData Connect Cloud

Note

This connector is owned and provided by CData.

Summary

Item Description
Release State General Availability
Products Supported Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported CData account (OAuth)
Function Reference Docs

Prerequisites

Capabilities supported

  • Import

Connect to CData Connect Cloud

Follow these steps to connect to your CData Connect Cloud account:

  1. In Power BI Desktop, select Get Data.

  2. In the search field, enter CData.

  3. Select CData Connect Cloud in the list and then select Connect.

    Screenshot of the Get data dialog where you select CData Connect Cloud.

  4. In the CData Connect Cloud connection window, select Sign in.

    Screenshot of the authentication dialog where you sign in to your CData Connect account.

  5. In the sign-in window, enter your CData Connect Cloud sign-in information, and then select Continue.

    Screenshot of the CData sign-in window.

  6. Select Connect in the connection window.

    Screenshot of the authentication dialog where the connection is finalized.

The Navigator window appears and allows you to import your data.

Import data

With the Navigator window open, follow these steps to access your CData Connect Cloud data:

  1. Expand the CData Connect Cloud tree. Your connections appear as subtrees.

  2. Select the data from each connection that you want to import.

  3. Select Load or Transform Data.

    • Load instructs the connector to execute the underlying query to CData Connect Cloud.
    • Transform Data launches the Power Query editor and allows you to adjust the query before loading the data. When you're finished using the Power Query editor, select Close & Apply in the navigation ribbon to apply your changes and load the data.