How to share custom functions to other semantic models

[abpgupta]

Hi All

Is there any way to share Custom functions to other dataflows and semantic models? I would like to share some of the common custom functions created via Dataflow in Service.

Thanks for inputs.

[collinq]

Hi @abpgupta ,

In addition to @lbendlin answer, I am wondering if you are meaning that you just want to copy the steps from the dataflow?  If so, you can just copy from Advanced Editor.  Or, you could use a template with the functions you want in it and then branch off of that .  If I am being too "simple" then @lbendlin answer will be the way to go.

[abpgupta]

I am looking to access Dataflow a library of custom functions and can be used as linked entity in other dataflows or semantic model. With that, I can just do version control of Dataflow instead of individual custom functions. 
For copy as text option, I am already using sharepoint with version history for each function. Problem with that is if I change/enhance function, all users need to copy code again. As linked entity, it should work like Power query native M functions.

[collinq]

Hey @abpgupta ,

Thanks for the clarification - if you are wanting versions then usign github like @lbendlin suggested is probably the best way to go.

[abpgupta]

Thanks. I am looking for exposing all of them as library with a Dataflow.

[lbendlin · Accepted solution]

You can copy queries into a text repository or github and paste them into other dataflows. 

If you want to go all out you can read here :  Power Query M Primer (Part 25): Extending the Global Environment | Ben Gribaudo