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

Hi SamSantos,

maybe its worse checking out the limitations of UDFs here. Just to varify if you have one of these applied.

If not I would consider checking the syntax of your UDF, as in my case in the beginning this was the issue. Here a code of mine which acutally works and then shows the fields/parameters in Power BI:

import fabric.functions as fn
import uuid

udf = fn.UserDataFunctions()

# ===============================
# UDF: update_defect_resolution
# ===============================

# Take a defect id, resolver, resoltuion notes and parts replaced (Status will be set automatically to "closed" as this is the intended action) as input parameters
# Write the data back to the SQL database
# Users will provide these parameters in the PowerBI report
@udf.connection(argName="sqlDB",alias="DBSTOREDemo") 
@udf.function() 
def update_defect_resolution(sqlDB: fn.FabricSqlConnection, 
                            defectid: int,
                            resolvedby: str,
                            resolutionnotes: str,
                            partsreplaced: str) -> str:
    """
    Updates defect tracking record in the operational SQL database.
    Status is default set to "Closed" if a resolution is entered.

    Parameters:
    -----------
    defectid : int
        Unique identifier of the defect record.
    resolvedby : str
        Name or ID of the maintenance worker.
    resolutionnotes : str
        Description of how the defect was resolved.
    partsreplaced : str
        Comma-separated list of parts replaced.

    Returns:
    --------
    str
        "Defect resolution updated successfully."
    """

    try:
        # Establish a connection to the SQL database  
        connection = sqlDB.connect() 
        cursor = connection.cursor() 

        # Update query
        query = """
        UPDATE [maintenance_demo].[defect_tracking]
        SET resolved_by = ?,
            resolution_notes = ?,
            parts_replaced = ?,
            status = 'Closed',
            resolution_timestamp = GETUTCDATE()
        WHERE defect_id = ?
        """

        # Execute update
        cursor.execute(query, (resolvedby, resolutionnotes, partsreplaced, defectid))
        
        # Commit the transaction 
        connection.commit() 
        cursor.close() 
        connection.close() 

        return "Defect resolution updated successfully."

    except Exception as e:
        return {
            "defect_id": defectid,
            "status": "Error",
            "message": str(e)
        }

If this also does not help I recommend checking out the tutorial example as this have to work out anyway. If this also does not work I assume maybe some configuration is missing or it is indeed a issue somewhere in your environment and I recommend opening a issue to Microsoft to help you out.

You can submit a ticket via the Microsoft Power BI Support Portal:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

Hi SamSantos 

did you click on the data function and then click Import?

I just followed the steps provided in this video and it works for me https://www.youtube.com/watch?v=voM47CcPa9s