Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Is it possible to publish Power Query functions?

‎10-07-2022 04:00 AM

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?

 

DenisSipchenko_0-1665140353884.png

 

Labels:
Message 1 of 2
351 Views
0
1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

‎10-07-2022 10:50 AM

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

View solution in original post

Message 2 of 2
302 Views
1 REPLY 1
ImkeF
Super User
Super User

‎10-07-2022 10:50 AM

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

Message 2 of 2
303 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All