Forum Discussion
User Data Function not accessible from PBI Desktop
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!
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.
-
2 Replies
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.
-
