"Users should be able to make their own functions and codes and post them on the community so that everyone can share the functions and codes." Basically, there are sort of functions/codes embedded in Power BI. However, those are just for numerical, literal(arranging text..etc) rearranging. For making Power BI deal with big data, there should be custom function. It is like custom visuals, we already have. For example, sometimes we need a function to convert zipcode column to longitude / latitude column. Or we will need a function inferring the capital city from given City/Country columns. It is not embedded. It should be realized through Custom(user) function. Users can find the specific functions they want on the community board and import it to their Power BI then use it.
4 Comments
- Power BI desktop should be able to automatically download each function that is explicitly mentioned in someone's code. For example if I type: Variable = OnLineDepository:SomeFunction(x,y), PBI would automatically download that function from OnLineDepository and it will be added to my PBI file.
- I think this would be good for Power Query and DAX. Getting Latitude and Longitude would be Power Query. Calls to AI could be easier if web calls could be encapsulated in a function and made available in a library, maybe AI calls from DAX
Note there's an Idea for custom functions in DAX: Microsoft Idea (powerbi.com)
It doesn't cover the shared user board aspect mentioned in this Idea. However, getting custom functions in general added to DAX (M already has them) is the first step before they are shared.
There's also an Idea for a user function repository: Microsoft Idea (powerbi.com)
Having a user repository that can store DAX and M functions may also be a good first step to offering this functionality.
- Status added:Needs Votes
