Write Back to Power bi dataset on LakeHouse

[jaryszek]

hi Guys,

Is it possible to have write-back feature within Power Bi report, but based on DirectLake Over OneLake?

Or only it has to be SQL endpoint ?

Can anybody help and send some docs about it?

Best,
Jacek

[amitchandak]

@jaryszek ,Using translytical Task flows, you can. I have tried for Warehouse and SQL DB. But you can have to lakehouse files. 

Power BI Data Write-back Feature via Translytical Task Flows: https://youtu.be/2giHs13KUDI

[jaryszek]

thank you

[rohit1991]

Hii @jaryszek 

DirectLake and Lakehouse datasets do not support write-back directly from a Power BI report. DirectLake is read-only, so you cannot update tables in OneLake from visuals or DAX. Write-back is only possible through an external endpoint such as SQL, API, Power Apps, or custom web service that writes data back to the Lakehouse/SQL. Power BI itself cannot write data back to a DirectLake model today.

[jaryszek]

Thank you, 

so what could be a workaround for writing back from Excel/CSV file into power bi semantic model on DirectLake over OneLake?

Best,
Jacek

[v-prasare · Accepted solution]

Hi @jaryszek,

write the data to the underlying OneLake/Lakehouse instead of the model itself. For example, users can upload Excel or CSV files, and then use Fabric Dataflows, Notebooks (Spark/Python/SQL), or Translytical Task Flows to ingest that data into Lakehouse Delta tables. The DirectLake semantic model then reads this updated data after a refresh.

Thanks,

Prashanth