Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Make Power BI data editable

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 da...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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