Forum Discussion

Mohan128256's avatar
Mohan128256
Helper IV
10 months ago
Solved

Translytical Task Flow – Create/Edit Not Reflecting in Report (Only Delete Working)

Hi all, I’m working on a Translytical Task Flow, first i have followed this link ((https://learn.microsoft.com/en-us/power-bi/create-reports/translytical-task-flow-tutorial)) everthing went well so ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    10 months ago

    Hi Mohan128256,
    Thanks for the update and follow-up question.

    It sounds like your SQL logic is fine, but the issue is with how inputs are passed from the report to your User Data Function. Since all values are typed together (like 1,test1,test2…), Power BI can’t identify which value belongs to which parameter, so it’s mapping them randomly. Please try this below I mentioned:

    Create separate text inputs for each field PageNo, ReportName, PageName, ReportDescription, and ReportLink. Go to your Submit button → Format → Action → User Data Function, and make sure each parameter is mapped to the correct input visual. For optional Add a message box to show the success message after submission. After mapping them separately, the record should be created with correct values.

    Hope this clarifies it. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
10 months ago

Hi Mohan128256,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to BeaBF, for his inputs on this thread. And detailed explanation and for sharing your modified function that helps a lot.

From what you described, your backend logic for create/update/delete is working correctly (since you can verify the SQL table changes). However, the issue is that Power BI visuals don’t automatically refresh after a create or update operation only after a delete.

Here is what you can do to fix this: Make sure your dataset is using DirectQuery mode, not Import. Edit your button → Add a “Refresh visuals” action under Format → Action → + Add action. Set it to trigger after the User Data Function completes successfully. Double-check that your input fields (especially ReportName and PageName) are correctly mapped to the function parameters.

Once done, your new and edited records should appear in the report right after you click Submit.

Hope this helps. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.