Can users update data

[Sbudd]

I have a dashboard that shows errors in data, and the team of about 10 people willgo through those errors and fix the source data. 

Is there anything that can be used to update dashboard that the error is fixed/being looked at?

[V-yubandi-msft]

Hi @Sbudd ,

Thank you for engaging with the Microsoft Fabric Community. Particularly about using Power Apps and DirectQuery for near real time updates.

Additionally, a practical approach for tracking progress is to integrate Power BI with a SharePoint list or Excel file. This allows your team to log the status of each error (Open, In Progress, Resolved) without modifying the source data directly in Power BI.

Thank you for the valuable insights @GrowthNatives .

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[GrowthNatives · Accepted solution]

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! 🚀