This section shows how to set up ODBC connectivity and configure DSNs on macOS.

Minimum macOS Version

The CData ODBC Driver for Microsoft Power BI XMLA driver requires macOS Sierra (10.12) or above.

Licensing the Driver

In a terminal, run the following commands to license the driver. To activate a trial, omit the <key> input.

cd "/Applications/CData ODBC Driver for Microsoft Power BI XMLA/bin"
sudo ./install-license.sh <key>

You'll be prompted for a name and password. These refer to your name and your machine's password.

Connecting to Microsoft Power BI XMLA

To connect, set the Workspace property to a valid PowerBIXMLA workspace (ex: CData).

To connect to multiple workspaces at the same time, simply supply a comma-separated list of workspaces.

Uninstalling the Driver

The easiest way to uninstall the driver is to open a terminal and run the included uninstall.sh script, located in the installation directory. For example:

cd "/Applications/CData ODBC Driver for Microsoft Power BI XMLA"
sudo ./uninstall.sh

Note: The script needs to be run from the installation directory.