Forum Discussion

VivekGoli1203's avatar
VivekGoli1203
Regular Visitor
1 year ago
Solved

Publishing a User Data Function is giving error

I have created a Fabric SQL Database. Created a User Data Function and added the connection to SQL Database in Manage Connections section of the UDF. Then I have pasted the sample code that Microsoft...
User Data Functions
VivekGoli1203's avatar
VivekGoli1203
Regular Visitor
1 year ago

I am trying to implement write back in a Power Bi report, so as per the newly introduced translytical workflows tutorial it asked to create a UDF that takes values from report as parameters and updates them in the Fabric SQL Database.

BhaveshPatel's avatar
BhaveshPatel
Super User
1 year ago

This write back functionlity in Power BI is not available in User Defined Functions. You should do (write back functionilty) this in DWH aka Data Lakehouse. ( in Apache Spark with Python and INSERT ) . I will give you an example:


Writing data back to Azure SQL Database


# Create DataFrame to insert into the Azure SQL table ( Writing Data to Azure SQL Table )
#  
df1 = spark.createDataFrame([('WL2456', 'Luke1293', 'Skywalker','Null','Null',-3,'Unknown','Unknown','Null')], ['DeviceID', 'DeviceName', 'DeviceDesc','OperatorName','OperatorDesc','FacilityID','FacilityName','FacilityDesc','DeviceSerialNo'])

# Insert the rows into the Azure SQL table
df1.write \
    .option('user', user) \
   .option('password', pswd) \
   .jdbc('jdbc:sqlserver://' + sqlserver + ':' + port + ';database=' + database, 'dbo.Devices', mode = 'append' )
   
   
df1.show()