Sébastien De Bosscher on 27 Apr 2020 00:59:28
In many pbix files I reuse the same custom made M-functions.
Today I can only do so by opening an existing pbix file which contains that code and then manually copy/paste that query in my new pbix.
Please add the ability to save custom M functions to reuse in other pbix using the User Interface. Similar to a personal (or online) version of AppSource for the custom visuals, but then for custom M functions.
This can improve consistency in data transformations, speed of development, empower others in your organisation to reuse your code.
- Comments (4)
RE: Reuse custom Power Query functions
Good information, thankssehackear.top
RE: Reuse custom Power Query functions
(The suggestion from May 2023 about Git reuse is great and may help at a source code level, but this does not provide for linkage to an existing published function. Ideally want to link to function fred() in a dataflow such that if fred() is republished then we are using the new improved fred mk2. Much as a report links to a semantic model in the service and gets to reference its DAX measures, but for Power Query at the ETL stages.)
RE: Reuse custom Power Query functions
I support this suggestion but would like this to be done on the Power BI Service - such that a function can be public (akin to "loaded" for a table- i.e. visible to other dataflows/semantic models) - and that this can be consumed within other dataflows and/or PBI desktop source files. At present the only way I know to do this is by a custom connector, which does not include all use cases and also requires a Gateway server even if the code within the function does not require it
RE: Reuse custom Power Query functions
Or enable this reuse via git: please finish this idea with 1000s of votes: https://ideas.powerbi.com/ideas/idea/?ideaid=9daf5a6b-19e1-4b79-9e7c-78d877d54542