User Data Function not accessible from PBI Desktop

[Mauro89]

Hi there,

I have created a User Data Function item in my WS. I started with adding a single function to it. That worked. Then I added a second function in the same User Data Function item. After that I can not select any of them anymore in PBI Desktop. It just shows "None" in the drop down.

The respective button shows this message when hovering over it:

Any ideas what might be the issue here?

Thanks and best regards!

[rohit1991 · Accepted solution]

Hi @Mauro89 

when one function in the User Data Function item isn’t valid, Desktop hides the whole list.

Could you please follow below steps:

• In Fabric, open the UDF item >> check each function:

  • Has a Display name.

  • Only supported parameter types (Text, Whole/Decimal Number, Date/DateTime, Boolean).

  • Enabled and Saved/Published (no draft).

• In Desktop: Update to latest >> File >> Options >> Preview features >> turn on Data functions (Fabric) >> restart.

• On the button: pick the correct Workspace >> Function set >> then Data function.

• Permissions: you = Contributor on the workspace and Viewer+ on the Lakehouse/Warehouse used by the functions; same tenant account.

• Clear cache: File >> Options & settings >> Options >> Data Load >> Clear cache; sign out/in.

Quick isolate: temporarily disable/delete the new function. If the list comes back, that function’s definition is the issue.

[Mauro89]

Hi @rohit1991,

I figured it out. I had a wrong datatyp defined. Also interesting that I was despite that able to publish the function without any error.
Thanks for the supportive ideas.

Best regards!