Hi @RajK2 ,
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 setup
Option 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.
