Microsoft announced the PowerBI Data Connector SDK Developer Preview.
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.
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.
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.