Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
How to create Power BI Power App write backs with Fabric Direct Lake
Pease only reply if you know the answer. (Frankly it is annoying and ban manners when members don’t read the question.)
I know how to create normal Power BI Power App write backs using composite semantic data models with a combination of import mode and direct query tables.
I am now using a Semantic Data model with Direct Lake tables and want to create a Power App write back.
Direct Lake does not support composite data models and a Lakehouse is read only and won’t support write backs.
I’ve seen YOUTUBE videos how to use Power Automate flow inside a Power App inside a Power BI, but it only works with Fabric Warehouse. It wont work for a Lakehouse.
Can I connect the read only Direct Lake semantic model as a local live connection, then added a relationship to a read/write Dataverse table. Or will it fall back?
Has anyone out there had any success creating write back functionality alongside Direct Lake semantic data models please?
Thank you
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.
No 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.
The only semi usable option is to have a SQL source (on prem or Azure) in Direct Query mode.
User | Count |
---|---|
93 | |
90 | |
90 | |
81 | |
49 |
User | Count |
---|---|
156 | |
145 | |
104 | |
72 | |
55 |