Forum Discussion

Sbudd's avatar
Sbudd
Helper II
1 year ago
Solved

Can users update data

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 er...
  • GrowthNatives's avatar
    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! πŸš€