PowerBI Data Connector SDK Developer Preview. Microsoft announced the developer preview of the Data Connector SDK. It allows you to connect to data within Power BI.

Data Connectors for Power BI enable users to connect to and access data from your application, service, or data source, providing them with rich business intelligence and robust analytics over multiple data sources.

How to begin

You can begin to use the preview by installing the Power Query SDK from the Visual Studio Marketplace and creating a new Data Connector project. You can define your logic within this project.

Building the project will create an extension file.

You will then want to create a directory called extensions within your Power BI Desktop\bin folder. It should be in C:\Program Files\Microsoft Power BI Desktop\bin\ by default. Then copy the extension file to that directory.

During this preview, you will need to enable an environment variable to enable the use of extensions within Power BI Desktop. Custom Data Connector consumption experiences will be offered as a preview feature within the Power BI Desktop options starting with the June release.

You should see your connector in the Get Data list.

What you can do with a Data Connector

Data Connectors allow you to create new data sources, or customize and extend an existing source. Common use cases include:

  • Creating a business analyst friendly view for a REST API
  • Providing branding for a source supported by an existing connector (such as an OData service, or ODBC driver)
  • Implementing an OAuth v2 authentication flow for a SaaS offering
  • Exposing a limited/filtered view over your data source to improve usability
  • Supporting different authentication modes when creating a Power BI Content Pack
  • Enabling DirectQuery for a data source via an ODBC driver

Currently, Data Connectors are only supported in Power BI Desktop.

More improvements and updates are coming, and you can stay tuned to the Power BI blog for these updates. Please give the preview a try and share your feedback! You can provide feedback, report issues or add feature requests through the GitHub issues page of the Data Connectors repo.