Writing in the semantic model of a pbi with udf functions????

[jesuslogmein]

I am researching the new udf functions of fabric but I can't manage to write in a semantic model, I don't know if it is possible.

What I want is to put a button in a pbi and when the user clicks it, an OK is sent to the model.

Is this possible? does anyone have an example?

[v-saisrao-msft · Accepted solution]

Hi @jesuslogmein,

It is not possible to write values into a Power BI semantic model (dataset) through a button click or any interaction within a Power BI report, including with UDFs in Microsoft Fabric. 

Power BI semantic models are read-only from the report side and are designed for querying data using visuals or DAX, not for writing back data from user interactions. This is by design, for security, performance.

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[jesuslogmein]

Yes, although it would be ideal to write directly to the lakehouses. If that’s not possible, we can export the data as a CSV file and then ingest it into the lakehouse????