Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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
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.
Unexpected token '<', "<!--# QVsM"... is not valid JSON
Link to tutorial : https://learn.microsoft.com/en-us/power-bi/create-reports/translytical-task-flow-tutorial
Solved! Go to Solution.
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
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 )
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:
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
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.
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.
Hello Prashanth, Please respond if you find any solution
Hi @VivekGoli1203,
we are looking to your scenario and will post answer once were tried reproducing it.
Thanks,
Prashanth Are
MS Fabric community support
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.