Option of data writeback based on buttons Approve or Reject

[UPF1KOR]

Hi,

I have a project feasibility study whether, it can be done in Power BI or not. 

Refer below mockup. We have monthly data for a parameter or anything on Power BI Cloud report . I need to have buttons for end user saying Approve or Reject or Yes or no and then save. It will on Power BI cloud report or say published App. 

On save or Approve, the new numbers will be written back  (I am assuming Power App) in the data source like On Prem Oracle database.

On Dont save or Reject, the old numbers will still in database and no new writeback happens (It willl be even better to show it here as Previous: 90.00 )

Just want to understand:

1. whats the potential approach I can go with?

2. Is it even feasible to do in Power BI?

3. If feasible as well, will it be best approach to do it here OR it's better to do in Web applications?

Thanks a lot in advance for your time...
 

[v-veshwara-msft]

Hi @UPF1KOR ,
Thanks for sharing your question in Microsoft Fabric Community.

The links provided by @kushanNa are good references to start with.

Just to add some clarity, Power BI by itself does not support direct writeback to a database. In these scenarios the usual approach is to embed a Power Apps visual in the report. User actions such as Approve or Reject can then be captured in the app and, with the help of Power Automate, written back to Oracle through a gateway if the database is on-premises. If the user rejects, no update occurs and the existing values remain in the source. This pattern works well for light approval or data entry use cases, while larger scale transactional updates are usually better handled in a dedicated application with Power BI consuming the results for reporting.

Here is a similar thread  which you might find helpful: Writeback functionality in Power BI Desktop - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[kushanNa · Accepted solution]

hi @UPF1KOR 

Please check if these two links helps you 

https://www.youtube.com/watch?v=uPHwjPRnRwE&t=20s&ab_channel=HowtoPowerBI 

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-oracledb