Forum Discussion
Possible to create a Table Visual through which users can modify excel source data?
- 4 years ago
Hi botayone
Yes, in most cases Power BI is read-only, and does not provide write-back to update data. You can do this in Power BI with a Directly connected datasource, and tools like PowerApps Business Apps | Microsoft Power Apps which lets you build data-entry screens that can be incorporated into Power BI reports. Or you can use a third-party solution like PowerOnBi Add Write-Back Functionality to Power BI with Power ON Visual Planner (poweronbi.com)
Hope this helps
Stuart
Hi botayone
Yes, in most cases Power BI is read-only, and does not provide write-back to update data. You can do this in Power BI with a Directly connected datasource, and tools like PowerApps Business Apps | Microsoft Power Apps which lets you build data-entry screens that can be incorporated into Power BI reports. Or you can use a third-party solution like PowerOnBi Add Write-Back Functionality to Power BI with Power ON Visual Planner (poweronbi.com)
Hope this helps
Stuart
Thank you for the confirmation, Stuart!
I will look into PowerApps but suspect that the data-entry screens will not be as user friendly as excels, where users currently filter on their name in the action owner column and then select the status column from a pull-down list.
Would be quite cool if this were the Power BI development roadmap.