Miguel on 24 Aug 2017 09:40:54
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:
https://youtu.be/76W1Cu1qSfw
https://youtu.be/Q06NKl8A4eI
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.
- Comments (11)
RE: Custom Connector as a Portable Library of Functions
It works great, just what I needed!
RE: Custom Connector as a Portable Library of Functions
This worked out perfectly for what I needed. Thanks. I hope it gets published as an official tool.
RE: Custom Connector as a Portable Library of Functions
A great concept from the Power User, please support this idea Microsoft
RE: Custom Connector as a Portable Library of Functions
Please make it happen
RE: Custom Connector as a Portable Library of Functions
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*
RE: Custom Connector as a Portable Library of Functions
Agree, this would be a huge step forward!!
RE: Custom Connector as a Portable Library of Functions
Same here.
Same needed for custom PQ functions.
RE: Custom Connector as a Portable Library of 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.
RE: Custom Connector as a Portable Library of Functions
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.
RE: Custom Connector as a Portable Library of Functions
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.