Forum Discussion
Writeback
I've created table like column
Quarter / Item / value / comments
I've published the report so end user need to update 'Comments' on each rows in PBI online and save it.
suggest the simple work around.
Thanks!
Anonymous
Not sure how simple you wanted it to be:) One of the ways would be by leveraging Power Apps with dataverse. I would recommend you follow this tutorial from Bas.
https://youtu.be/uPHwjPRnRwE?si=paDAoyGVnZ-L8tju
Thanks.
6 Replies
- MasonMASuper User
Anonymous
Not sure how simple you wanted it to be:) One of the ways would be by leveraging Power Apps with dataverse. I would recommend you follow this tutorial from Bas.
https://youtu.be/uPHwjPRnRwE?si=paDAoyGVnZ-L8tju
Thanks.
- burakkaragozSuper User
Hi Anonymous ,
Great question — and you're definitely not alone. What you're trying to do is a classic writeback scenario, and while Power BI doesn't support direct writeback natively, there are a few workarounds depending on how "simple" you want it to be.
Option 1: Power Apps + Dataverse (as MasonMA suggested)
This is the most robust and scalable method:
- Embed a Power Apps form directly into your Power BI report.
- Connect it to a Dataverse table (or SharePoint list, SQL, etc.).
- Users can enter comments per row, and the data is saved back to the source.
✅ Pros: Fully integrated, secure, scalable
❗ Cons: Requires Power Apps license and setupOption 2: Power Apps + SharePoint List (simpler backend)
Same idea as above, but instead of Dataverse, use a SharePoint list to store comments. Easier to set up if you're already using SharePoint.
Option 3: Use Excel Online as a comment backend
- Create an Excel file in OneDrive or SharePoint.
- Use Power Automate to sync comments from a form or Power Apps into that Excel.
- Connect Power BI to that Excel file to reflect updates.
Option 4: Third-party tools
There are tools like Power ON, Acterys, or Inforiver that offer writeback capabilities directly inside Power BI — but they usually require licenses.
Let me know which direction you’re leaning toward — happy to help you build a quick prototype.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was supported by AI for translation and text editing.
- AnonymousNot applicable
Hi Anonymous ,
Thanks a lot burakkaragoz and MasonMA both for your time and hited the key points spot on. Integrating Power Apps into Power BI is the most flexible and enterprise-friendly solution, and your breakdown of Dataverse vs SharePoint backend was very thoughtful.
Regards,
Akhil - AnonymousNot applicable
Hi Anonymous ,
I’m following up to confirm that all items discussed have been addressed. If there’s anything else you need, I’d be happy to assist.
Regards,
Akhil. - AnonymousNot applicable
Hi Anonymous ,
Just wanted to check were you able to wrap everything up on your end? If there’s anything still pending or if there any issue come up and let us know, Always happy to help.
Regards,
Akhil. - AnonymousNot applicable
Hi Anonymous ,
It’s been a little while, so I just wanted to check in one last time. Were you able to get everything up on your end.
Since we haven’t heard back, and following the Microsoft Fabric Community Forum guidelines, we’ll go ahead and close this thread for now. If you're still exploring solutions or need help with anything else in the future, please feel free to create a new post we’re always here to help.
Regards,
Akhil