Forum Discussion
Data function Button for running User Defined Function (UDF) is not configurable
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!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.
I appreciate the example, I'll give it a test. When you say you had syntax issues, do you mean you were able to get the UDF to run but not show in PBI and then had to change something? Or was the UDF not working until you changed some syntax and then connected it to PBI?
My UDF runs fine when testing online and I am getting records to write to the Fabric warehouse, but again, no options show in PBI Desktop for the Button Action. I've double and triple checked my PBI Preview options and have everything enabled. Plus. when I follow all the tutorials I've found online, I see that my Button Action options when I select Data Function are completely different than the examples. I'm wondering if this is a versioning issue.
Super UserSamSantos in my case the UDF showed up in Desktop but was not executing properly when used. That was due to syntax issues, eventhough the "testing" function of the UDF was saying everything is fine configured.
I see. Thanks Mauro89, not only did I need to switch to editting the report online as grazitti_sapna mentioned, it also looks like PBI did not like me trying to pass a date through. I had to change to only Strings and Integers and then PBI to allow me to connect to the Data Function in my Function Set.
- Mauro89
Awesome if grazitti_sapna and myself brought you to the solution 👍🏻
I had the same problem and I did not need to switch to editing online, but I did need to switch the parameter type from datetime.datetime to just datetime.
