The CData Power BI Connector for API is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.

Installing the Connector

Installing the Connector is a step-by-step guide for how to manage the installation process.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to API.

API Version Support

The connector models local XML/JSON files and remote REST service APIs as read/write tables. In addition to processing XML or JSON data, the connector also abstracts authentication, HTTP, and SSL/TLS: The major authentication schemes are supported, including HTTP Basic, Digest, and NTLM. The connector also facilitates connecting to data sources that use the OAuth authentication standard.

For an introduction to Visualizing Data using the CData Power BI Connector for API.