The CData Power BI Connector for Azure Table Storage 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 Azure Table Storage.

Azure Table Storage Version Support

The version support for Azure Table Storage varies based on the connector configuration.

If Backend is set to CosmosDB, the connector uses version 2019-02-02 of the Azure CosmosDB REST API.

If Backend is set to "AzureStack", "Storage", or "Emulator", then the API version used depends on the AuthScheme connection property:

• AuthScheme=AzureAD: The connector uses version 2017-11-09 of the Azure Storage REST API.
• AuthScheme=AccessKey: The connector uses version 2014-02-14 of the Azure Storage REST API.
• AuthScheme=SharedAccessSignature: The connector uses the version of the Azure Storage REST API that is specified in the "sv" parameter in the shared access key.
  • For example, if your shared access key has the value "sv=2018-03-28", the version used will be 2018-03-28.

For an introduction to Visualizing Data using the CData Power BI Connector for Azure Table Storage.