Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to publish&reuse Power Query custom functions (like datasets)?
For example, I want to publish and share fnSmartAndComplex function (and much more useful stuff), so everyone in organization can enjoy and reuse it in other reports?
Solved! Go to Solution.
Hi @Anonymous ,
currently this is not possible via one central repository. You have to use M-Extensions (Create a function library in Power BI using M-Extensions – The BIccountant") .
They have to be installed on every machine that used Power BI Desktop to design the reports and to work in the Power BI service, they have to be used via a gateway.
But there is light on the horizon, MS is working on a more convenient method: Save and curate a personal query collection in Power Query | Microsoft Learn - not sure about the details though, how this will be implemented.
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
Hi @Anonymous ,
currently this is not possible via one central repository. You have to use M-Extensions (Create a function library in Power BI using M-Extensions – The BIccountant") .
They have to be installed on every machine that used Power BI Desktop to design the reports and to work in the Power BI service, they have to be used via a gateway.
But there is light on the horizon, MS is working on a more convenient method: Save and curate a personal query collection in Power Query | Microsoft Learn - not sure about the details though, how this will be implemented.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.