The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Is it possible to create a utility dataflow to define all reusable functions and reference that utility in any dataflow that requires them? Similar to how scripting works in JavaScript or Python.
Currently, the only alternative is to rewrite the same function separately in each dataflow, since there is no way to define it once and reuse it across dataflows. This makes the process extremely cumbersome and inefficient, as the functions have to be manually duplicated every time.
@AlexisOlson @ImkeF @imkefeldmann
Solved! Go to Solution.
Not something that we support today, but it does sound like a good idea!
please do feel free to post the idea in the Fabric Ideas portal:
Yes, being able to reuse functions is a year-old dream of many Power Query fans that must have many different entries in the idea-section by now.
I don't specifically care how this is implemented - would be happy with just something that works...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
if you happen to come across this post, please vote for this idea
Not something that we support today, but it does sound like a good idea!
please do feel free to post the idea in the Fabric Ideas portal:
It is possible to load a list of functions into #shared but that is something you need to do manually for each semantic model. So it kinda defeats the purpose.