Forum Discussion

Mauro89's avatar
Mauro89
Super User
1 year ago
Solved

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 ...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    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.

rohit1991's avatar
rohit1991
Super User
1 year ago

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's avatar
    Mauro89
    Super User
    1 year ago

    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!