Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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!

6 Replies

  • 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 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.

  • Anonymous's avatar
    Anonymous
    Not 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

  • Anonymous's avatar
    Anonymous
    Not 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.

  • Anonymous's avatar
    Anonymous
    Not 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.

  • Anonymous's avatar
    Anonymous
    Not 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