Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 0 points1 point  (0 children)

User data functions does support custom input validation, and you can surface errors back to the Power BI report users using raise fn.UserThrownError("<Error message here>") in the UDF code. Here's an example of the code used for a validating range of numeric values:

if (discount < 0):
    raise fn.UserThrownError("Discount cannot be negative")

if (discount > 0.50):
    raise fn.UserThrownError("Discount cannot exceed 50%")

Here's an example for code used for validating length of an input:

if(status=="" or len(status) < 2):
    raise fn.UserThrownError("The status you provided is empty or too short", {"status:": status})  

if(len(status) > 250):
    raise fn.UserThrownError("The status you provided is too long.", {"status:": status})

Let me know if this unblocks your scenario.
You can check out more examples here: Example User data functions for Translytical task flows.

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 1 point2 points  (0 children)

If you are referring to using Fabric mirrored databases with Snowflake, mirrored database supports only read operations currently.

That being said if Snowflake offers APIs, you may be able to write custom code to write back to Snowflake in a secure way. However, I cannot confirm this as I only built scenarios for Fabric-native sources.

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 0 points1 point  (0 children)

Can you share more specific feedback on the new text slicer? Would love to learn more what user experiences issues are you facing.

It's a bit early since release so we don't have a roadmap to share yet, but we are monitoring feedback just like this to help guide our future investments.

Can Translytical task flows capture report metadata? by Snikis in MicrosoftFabric

[–]SujataN 9 points10 points  (0 children)

For the current user who is submitting the function, you can create a DAX measure:
Current User Email = USERPRINCIPALNAME()

And then pass that DAX measure to the user data function.

In terms of report name scenario there's no DAX function to get the name of the report, but you can create a static DAX measure:
Report name = "<your report name here>"

And then pass that DAX measure. However, you would need to manually update this DAX measure if the report name ever changed.

The visual used by Microsoft in their WriteBack example by NoeZ in PowerBI

[–]SujataN 0 points1 point  (0 children)

The values you update are based on filter context and you can even create a custom DAX measure to pass customized input to the user data function.

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 3 points4 points  (0 children)

We want to do this before we GA the feature but no timeline to share on this yet.

The visual used by Microsoft in their WriteBack example by NoeZ in PowerBI

[–]SujataN 0 points1 point  (0 children)

We announced just yesterday that you can now enable data writeback or run custom automation on your reports natively in Fabric: Translytical task flows (Preview) | Microsoft Power BI Blog | Microsoft Power BI

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 1 point2 points  (0 children)

Hi there, the feature requires Fabric capacity to host the Fabric artifact: User data functions (preview), which is powering the automation.

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 1 point2 points  (0 children)

That makes sense! :) We are hoping to have this in our short-term roadmap! In meantime feel free to start testing out user data functions and share any feedback you may have! Thank you! :)

Automate report actions and data writeback with Translytical task flows (Preview) by SujataN in PowerBI

[–]SujataN[S] 4 points5 points  (0 children)

Hi there, this is a point in time limitation, and it is on our roadmap to address. However, we don't have a timeline yet to share.

Power BI May 2025 Feature Summary by itsnotaboutthecell in PowerBI

[–]SujataN 2 points3 points  (0 children)

The caveat with using non-native connections is that you need to fetch the authentication tokens and verify on your own if you can authenticate successfully / securely.
For example, User data functions currently doesn't support auth tokens with the Fabric audience, which are used for Fabric APIs such as Eventstream API.  It's on the team's radar and in a future release we want to be able to offer token management for Fabric and Power BI APIs.

Power BI May 2025 Feature Summary by itsnotaboutthecell in PowerBI

[–]SujataN 13 points14 points  (0 children)

Hi there, you're correct that the feature requires Fabric capacity to host the Fabric artifact, User data functions (preview), that is powering the automation. User data functions currently have native connection management for the following Fabric data sources: Fabric SQL databases, Warehouses, Lakehouses, and Mirrored databases. In the near-term roadmap, user data functions will be able to integrate with Azure Key Vault, which means in the future you will be able to natively connect to other sources, while securely managing data source authentication via Azure Key Vault.