Forum Discussion
Super UserHow to create Power BI Power App write backs with Fabric Direct Lake
Hi speedramps ,
To create a Power App using Direct lake for write-back functionality, you can try to use Power Automate in combination with Dataverse.The relevant link is below, hopefully it will help you out:
Use a flow to add a row in Dataverse - Power Automate | Microsoft Learn
Best Regards,
Zhu
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserNo it didn't help.
Direct Lake does not currently support composite datamodels with Dataverse.
It is possible to add a Dataverse Onedrive Shortcut, but it takes Fabric over 20 mins to replicate .... which is far too slow for a Power App writeback to show on a Power BI report. I want it to be instant.
Same problem goes for a Power Automate.
Perhaps you misunderstood the problem. It is easy to writeback to a table .... but I need the Power BI report to refesh instantly with the Power BI Integration.Refresh command.
I know how to do it on non-fabric which supports composite data models with import mode and direct query tables. But Fabric Direct Query does not support composite tables.
- lbendlin
The only semi usable option is to have a SQL source (on prem or Azure) in Direct Query mode.
