Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
VivekGoli1203
Regular Visitor

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 Tutorial has given. Publishing the UDF is giving the below error.

VivekGoli1203_0-1751005661452.png

Unexpected token '<', "<!--# QVsM"... is not valid JSON

 

Link to tutorial : https://learn.microsoft.com/en-us/power-bi/create-reports/translytical-task-flow-tutorial

1 ACCEPTED SOLUTION
v-prasare
Community Support
Community Support

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

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

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

View solution in original post

9 REPLIES 9
BhaveshPatel
Community Champion
Community Champion

Just curious that why do we need User Data Function in Fabric SQL Database?? Use Kimball methodology/ Dimensional Modelling wherever we can. ( DimTable <--> Fact Table )

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

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.

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()
Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
v-prasare
Community Support
Community Support

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

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

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

Okay Prashanth thank you

v-prasare
Community Support
Community Support

Hi @VivekGoli1203,

As i have tried and implimeted below mentioned: Create a translytical task flow (https://learn.microsoft.com/en-us/power-bi/create-reports/translytical-task-flow-tutorial#test-the-s...)

when i run the UDF mentioned in the docs, it gives me success message without any errors. Can you try again once replacing the default code with the code given in the documentation. there might have been extra typos mistakes have added while copying code that might result in error.

 

vprasare_0-1751275451518.png

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If my answer helps please accept as solution, by doing this users with similar issues find answers easily.

 

I have used the correst code from the turorial, with correct data connection to Fabric SQL Database.

But it has given error in my tenant. But in other tenant of our organisation it worked fine.

VivekGoli1203
Regular Visitor

Hello Prashanth, Please respond if you find any solution

v-prasare
Community Support
Community Support

Hi @VivekGoli1203,

 

we are looking to your scenario and will post answer once were tried reproducing it.

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.