Custom Connector as a Portable Library of Functions
Currently, a custom connector requires a Data Source and a Authentication record associated to a function in order to be Published or exposed in the 'Get Data' dialog/window.
This is perfectly fine for data sources, but if I want to create a custom connector that creates data using native M functions, like. List.Generate or List.Dates, then I shouldn't have to define a Data Source nor an Authentication which complicates things and is an unnecessary step for the end user.
Here are 2 videos showcasing 2 functions that do not need any sort of authentication, but due to the way custom connectors currently need to be constructed, they get prompted for credentials as an "Anonymous" user:
The idea: to remove the need for a DataSource/Authentication record for custom connectors that act as library of functions so they can be published on the 'Get Data' dialog and not only shared as environment variables.
It works great, just what I needed!
Dale Sines commented
This worked out perfectly for what I needed. Thanks. I hope it gets published as an official tool.
A great concept from the Power User, please support this idea Microsoft
Absolutely, Igor! and your repo is completely supported at this moment with Custom Connectors.
The idea posted here is based on a scenario that quite different as it relies on multiple functions from the same connector being published to the 'Get Data' Dialog to provide the most user-friendly experience possible instead of relying on the user to manually input the name of the functions which is not so user friendly.
*More info about the current issues and suggested changes in the original idea description as well as videos*
Juan Carlos Olmedo Garcia commented
Please make it happen
Imke Feldmann commented
Agree, this would be a huge step forward!!
Same needed for custom PQ functions.
Was pretty much what I was looking for. I have used the same queries in many different places i.e. Different dashboards and excel spreadsheets. A central repository or library for these where they can be updated in one place but seen in multiple places is what I would like to see.
Allow connecting to / sharing of M functions and libraries. For example, I've been keeping a set of useful "utility" functions here: https://github.com/tnclark8012/power-query-extentions/blob/master/power-query-extensions.m
It would be great if I could share or import them in a convenient way, and perhaps reference them without the table syntax.