Make Power BI data editable

[Anonymous]

We are extracting data from SAP BW Application Server in Power BI. Every month new data is refreshed and loaded in Power BI Desktop. But further we need to enable users to make some changes in the data and add comments regarding the data. We want to provide an editable form/table in Power BI Desktop only that will allow users to edit data and add their comments. 

Once done we then want to use that data to display in Power Bi visuals. What would be better ? To use Power Apps or Power Automate ?

[mahoneypat · Accepted solution]

You should use Power Apps for that, and you have two main options.

1. Make a Power App that allows users to edit records in your SAP source. You can then add that app to your Power BI report, along with a Power Automate button to refresh the data in the Power BI report.

2. Make a SharePoint list or Dataverse table for users to supplement data (if they are just adding info, instead of changing existing records). That SharePoint list should include an ID column (to merge with the primary data), along with any new fields you want.

Pat