Eugene Roh on 19 May 2016 02:03:21
"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.
- Comments (2)
RE: Create user functions
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
RE: Create user functions
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.