Anonymous
Status:
Completed
Portable Library of Queries (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: 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.
15 Comments
- TaylorClark
Power BI Team
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. - TaylorClarkAllow 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.
- TaylorClarkAllow 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.
trevbAdvocate II
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.- Same here. Same needed for custom PQ functions.
- Please make it happen
TheGAdvocate I
A great concept from the Power User, please support this idea Microsoft- Agree, this would be a huge step forward!!
- 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*
- It works great, just what I needed!
