Forum Discussion
Helper IIITranslytical Flows
Hi All,
I am trying to use Udser Data Functions in Power BI to insert notes per user in the report. In the backend table, there are 2 columns - user, note. The note column will be written and inserted by user and the user column will be directly picked by Power Bi using USERPRINCIPALNAME() measure.
Can you please let me know how to do that in report. I read on Claude that I can use 'Translytical Flows' visual which I am not able to find. Can anybody please help me?
Regards,
Yashwant
Hi yashwant101 ,
Thanks for sharing meaningful insights parry2k, Kedar_Pande and Future_To_BI
From what I can see, Power BI is successfully recognizing your Data Function and exposing the Notes parameter for binding. Since only one parameter is showing up, it looks like Power BI is currently detecting just a single input parameter from the published function. Could you share the function signature from your Fabric User Data Function? For example:def insert_note( sqlDB: fn.FabricSqlConnection, note: str, userEmail: str ) -> str:If your function is designed to capture both the note and the current user's email, I would normally expect both parameters to appear in the button configuration for mapping.
One thing worth checking is whether the function was republished after any changes were made. If additional parameters were added later, Power BI may still be using the metadata from the previously published version.
Seeing the function definition will help confirm whether Power BI is only receiving a single parameter from the function or if something else is preventing the additional parameter from appearing.
For Reference : Tutorial - Create translytical task flow - Power BI | Microsoft LearnFeel free to reach us, Happy to assisst.
Best Regards,
Abdul Rafi
7 Replies
- Kedar_Pande
Super User
Add a button, set its action to run the User Data Function, and pass two parameters: the note from the text input, and USERPRINCIPALNAME() for the user.Make sure you are on a Fabric capacity and the translytical task flows feature is enabled in your tenant, otherwise the button action to run a UDF won't appear.
yashwant101Hi Kedar_Pande ,
Thank you for your response. I am getting the option to set the button action to Data Function - that means Translytical Flows is enabled in the tenant settings. The issue however is that I am not able to give multiple parameters. Below is the screenshot. Please have a look and let me know how to proceed
Thanks!
- Future_To_BI
Resolver I
Hi yashwant101
Create a table with columns such as UserEmail and Note.- yashwant101
Hi Future_To_BI ,
I do not understand how it will resolve my issue. My issue is that I am not able to pass through values like USERPRINCIPALNAME() or filters applied on the screen to the backend database
- parry2k
yashwant101 have you looked at this walkthrough blog post
v-moharafi-msftCommunity Support
Hi yashwant101 ,
Thanks for sharing meaningful insights parry2k, Kedar_Pande and Future_To_BI
From what I can see, Power BI is successfully recognizing your Data Function and exposing the Notes parameter for binding. Since only one parameter is showing up, it looks like Power BI is currently detecting just a single input parameter from the published function. Could you share the function signature from your Fabric User Data Function? For example:def insert_note( sqlDB: fn.FabricSqlConnection, note: str, userEmail: str ) -> str:If your function is designed to capture both the note and the current user's email, I would normally expect both parameters to appear in the button configuration for mapping.
One thing worth checking is whether the function was republished after any changes were made. If additional parameters were added later, Power BI may still be using the metadata from the previously published version.
Seeing the function definition will help confirm whether Power BI is only receiving a single parameter from the function or if something else is preventing the additional parameter from appearing.
For Reference : Tutorial - Create translytical task flow - Power BI | Microsoft LearnFeel free to reach us, Happy to assisst.
Best Regards,
Abdul Rafi- yashwant101
Hi v-moharafi-msft ,
Thank you for your response. I had to republish the code and the options are available now.
