The CData Power BI Connector for JSON 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 JSON.

JSON Version Support

The connector models local and remote JSON data sources as bidirectional tables. These can be local JSON files or remote JSON streams: RESTful APIs or file stores hosted on FTP servers or popular cloud storage providers. The connector abstracts processing JSON data and connecting to the remote data: HTTP/FTP, SSL/TLS, and authentication: The major authentication schemes are supported, including HTTP Basic, Digest, FTP, NTLM, and OAuth.

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