CODEWITHSUNDEEP
excelpowerquery
tbone
tbone

Reputation: 5865

Is it possible to write a custom Power Query Connector?

In Power Query under “From Other Sources”, we see a number of specialized providers (Facebook, SAP, SalesForce, etc).

I am interested in writing a custom provider to access a local proprietary data store that cannot be consumed via any of the built in connectors.

I am aware that "the recommended way" to access data stores that do not have a supporting connector is to expose & consume the data via an OData feed. However, I would very much like to have a user friendly interface such that the user can easily find the specific feed they want.

From playing with some of the different providers, it seems like there are 2 parts:

a) The UI for specifying mandatory connection parameters, and optionally choosing specific entities and filters
b) The provider of the physical data itself (Facebook.Graph(), Sql.Database(), etc)

Is there currently a way to write a custom Connector, or are Connectors 100% proprietary and only provided by Microsoft?

EDIT:

I should note, knowledgeable "no it's not possible and here's why I think so" answers are definitely encouraged. I'm mainly asking is it possible?

Upvotes: 5

Views: 1091

Answers (1)

Curt Hagenlocher
Curt Hagenlocher

Reputation: 20916

It's not currently possible, but it's an area we're actively exploring. However, we do not foresee allowing a custom UI to be built for a custom connector.

Upvotes: 6

Related Questions