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

Microsoft SharePoint Version Support

The connector supports all versions of Microsoft SharePoint that support the SOAP API. This includes: Windows SharePoint Services 3.0, SharePoint Server 2007+ (2010, 2013, etc.), and SharePoint Online. The connector models the custom lists of your SharePoint site as bidirectional tables; when you connect, the connector retrieves the metadata for these tables by calling SharePoint Web services. Supported authentication schemes are NTLM, Basic, Digest, Forms, Kerberos, SSO, STS (security token services), and SharePoint authentication cookies.

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