sebastiendeboss's avatar
sebastiendeboss
New Member
6 years ago
Status:
Needs Votes

Reuse custom Power Query functions

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.
power bi

4 Comments

  • Gerben_deBoer's avatar
    Gerben_deBoer
    New Member
    3 years ago

    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

  • james14's avatar
    james14
    New Member
    2 years ago

    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


  • james14's avatar
    james14
    New Member
    2 years ago

    (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.)

Recent ideas