Power BI Connector for Excel Services

Build 20.0.7587

Getting Started

The CData Power BI Connector for Excel Services 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 describes how to install the CData Power BI Connector for Excel Services.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to Excel Services

Connecting from Power BI

Getting Data shows how to connect to the DSN and build a query to Excel Services from the Get Data window.

Excel Services Version Support

The connector supports retrieving Excel data from SharePoint On-Premises and SharePoint Online, through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587