Solved: Modifiable table for contributor to add the data

vnqtrang · ‎07-25-2022

Hi

I have a usecase that user would like to modify the data in a table view then these modification will save to the database.

It would be a table in report and user can choose from a dropdown list to select the correct value if the display info is incorrect. It's kind like an excel table.

Hope I clear enough.

Thank you in advance for your advise.

Tg

Shahfaisal · ‎07-26-2022

I am not a fan of letting users update data using a reporting layer but I also understand that there are business scenarios that need this ability. The following resources should help you get started.

Write back to Database in Power BI (1-3) Power BI - https://www.youtube.com/watch?v=y5zx4le2Dsc

Write-back to database using Power BI with Power Apps - https://visualbi.com/blogs/microsoft/powerbi/write-back-into-sql-database-using-power-bi-with-power-...

View solution in original post

Shahfaisal · ‎07-26-2022

I am not a fan of letting users update data using a reporting layer but I also understand that there are business scenarios that need this ability. The following resources should help you get started.

Write back to Database in Power BI (1-3) Power BI - https://www.youtube.com/watch?v=y5zx4le2Dsc

Write-back to database using Power BI with Power Apps - https://visualbi.com/blogs/microsoft/powerbi/write-back-into-sql-database-using-power-bi-with-power-...