Can I write a custom Power Query Connector?

In Power Query, in the "From Other Sources" section, we see a number of specialized suppliers (Facebook, SAP, SalesForce, etc.).

I am interested in writing a custom provider for accessing a local, proprietary data warehouse that cannot be used with any of the built-in connectors.

I know that the “recommended way” to access data stores that do not have a support connector is to expose and consume data through the OData feed. However, I would really like to have a convenient interface so that the user can easily find the specific channel that they need.

After playing with some of the different providers, it seems that there are two parts:

a) A user interface for specifying the required connection parameters and, if necessary, selecting specific objects and filters
b) the provider of the physical data itself (Facebook.Graph (), Sql.Database (), etc.)

Is there currently a way to create a custom connector or are they compatible with 100% connectors and are provided only by Microsoft?

EDIT:

I should point out that those who know “no, this is not possible, and that’s why I think so” answers are definitely encouraged. I basically ask if this is possible?

+4
source share
1 answer

This is currently not possible, but this is an area that we are actively exploring. However, we do not anticipate that a user interface will be created for the user connector.

+5
source

Source: https://habr.com/ru/post/1598453/


All Articles