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?
tbone source
share