Forum Discussion

Theandster33's avatar
Theandster33
Frequent Visitor
2 years ago

Updating a Single Cell

Hello, I am currently attempting to make a dashboard to be able to display what the "current # of filters" and "remaining powder" to keep up to date on supplies. I am using power autmoate with a "for a selected file" trigger to auto populate an excel sheet in sharepoint. This excel sheet is then fed into the powerbi API live dataset.  When I make these graphs, gauges ect, it always takes the sum of all the previously entered values instead of the most recent value.

 

Is there a way to just have powerbi  "replcae a cell in the dataset instead of "adding to a dataset" which is what I think is happening. I just want to display the most recent value for "current # of filters" and "powder remaining", not the sum of the entire historical data.

 

 

Thanks!

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Theandster33 ,

    To ensure that Power BI displays only the most recent values for a particular data set, you can take advantage of the incremental refresh feature with real-time data capabilities. Here are some steps to do this:
    1. To configure incremental refresh, create two parameters in the Power Query Editor called RangeStart and RangeEnd. I recommend you to read the following link:

    Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn
    2. If you want to apply the incremental refresh policy in Power BI Desktop. In the policy settings, specify the historical data period and the refresh period. Requires that you have Power BI Premium. enable the Get Latest Data in Real Time with DirectQuery setting to get real-time updates. Use XMLA to incrementally refresh:

    Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn
    3. Save the Power BI model and publish it to the Power BI service. Perform an initial refresh that loads historical data for the entire storage period and new data for the refresh period.
    After following these steps, your Power BI reports should display the latest values without having to sum the historical values.

     

    Updating Individual Cells:
    With respect to Power Automate and your Excel worksheets, to replace cell values instead of adding them, you can use the Update Rows action. This action allows you to specify the Excel file, table, and rows, and then provide new values for the cells you want to change.

     

    Best Regards,

    Ada Wang

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