Forum Discussion

SamSantos's avatar
SamSantos
Frequent Visitor
8 months ago
Solved

Data function Button for running User Defined Function (UDF) is not configurable

I have created a User Defined Function button to writeback date from Power BI to a Fabric Warehouse. The UDF works when testing online and writes to the table and returns a string, but in PBI Desktop...
  • grazitti_sapna's avatar
    8 months ago

    HI SamSantos,

     

    You're not doing anything wrong β€” this is a known limitation and partial rollout issue with Power BI Desktop + Fabric Data Functions, This feature is NOT fully available in Power BI Desktop yet.

     

    You can try enabling below options in power BI desktop 

     

    Power BI Desktop β†’ Options β†’ Preview

    Data functions

    Fabric Business Operations

    Write-back

    Direct Lake (if needed)

     

    if it doesn't work, you can edit the UDF in Power BI service and test.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    πŸ’‘ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    πŸŽ– As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    πŸ”— Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • SamSantos's avatar
    SamSantos
    8 months ago

    Hi grazitti_sapna, thanks for this detail! Yes, when i published the workbook to my workspace and editted the report online, the Data Funciton options were made available to me. I did not realize that this was currently an online only function.