Forum Discussion
Can users update data
- 1 year ago
Hi Sbudd,
Yes, there are several ways to support this workflow in Power BI, but Power BI itself does not allow users to update the data directly from within the report (it's read-only from a consumption perspective). However, you can enable a workaround process to track or reflect updates made by users.
Option 1: Use Power Apps Embedded in Power BI (Recommended)
In my opinion, this is the most optimal approach for your scenario.With Power Apps visual, you can embed a form directly inside the Power BI report that allows users to:
Select an error
Update its status or notes
This form writes back to a SharePoint list, SQL table, or other data source.
Power BI reads from that source, and you see the updates on refresh.
Option 2:Scheduled Refresh or DirectQuery (Alternative Option)
If the source system where the data is fixed is directly accessible (e.g., SQL, Dataverse):
Use DirectQuery or frequent scheduled refreshes (e.g., every 15-30 mins)
Then Power BI reflects changes made by the users fixing the data
You can optionally show "last refresh time" to reassure users itβs up to date.
βHope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
π‘Found it helpful? Show some love with kudos π as your support keeps our community thriving!
πLetβs keep building smarter, data-driven solutions together! π
Hi Sbudd,
Yes, there are several ways to support this workflow in Power BI, but Power BI itself does not allow users to update the data directly from within the report (it's read-only from a consumption perspective). However, you can enable a workaround process to track or reflect updates made by users.
Option 1: Use Power Apps Embedded in Power BI (Recommended)
In my opinion, this is the most optimal approach for your scenario.
With Power Apps visual, you can embed a form directly inside the Power BI report that allows users to:
Select an error
Update its status or notes
This form writes back to a SharePoint list, SQL table, or other data source.
Power BI reads from that source, and you see the updates on refresh.
Option 2:Scheduled Refresh or DirectQuery (Alternative Option)
If the source system where the data is fixed is directly accessible (e.g., SQL, Dataverse):
Use DirectQuery or frequent scheduled refreshes (e.g., every 15-30 mins)
Then Power BI reflects changes made by the users fixing the data
You can optionally show "last refresh time" to reassure users itβs up to date.
βHope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
π‘Found it helpful? Show some love with kudos π as your support keeps our community thriving!
πLetβs keep building smarter, data-driven solutions together! π