Incremental refresh

[leandross89]

Hello community,

I need some help. I created a report in Power BI Desktop and published it to the Power BI Service. I configured incremental refresh in the Desktop, but it doesn't work in the Power BI Service.

I don't know why it isn't working. I created the parameters as RangeStart and RangeEnd and enabled incremental refresh with the correct configuration.

When I scheduled the data update, the update completes without errors, but I noticed that the report doesn't show the new data (the current day's data). It only shows the data that was initially published.

My report contains 4 tables (bateria, temperatura, apn, and reset), and I used an append query to combine them into one table (Apn). I'm unsure if there is a limitation when handling multiple CSV files.

I can share screenshots of each step, including the 4 tables, RangeStart, RangeEnd parameters, and the model as it was created.

4 tables, RangeStart, RangeEnd 

table that was appended queries

incremental refresh configuration, I did it in the 4 tables.

I have already implemented theses steps in another report (without append queries), and it is working well, but this report isn't working.

Thank you for your assistance.

[leandross89]

When I change the RangeEnd parameter to another date in the future as 07/03/2027, the report update the data with current data. But I don´t know if I configure the parameter in that way it´s correct or not.

[Anonymous]

Hi @leandross89 

Setting RangeEnd to a future date is a workaround that forces Power BI to include more data in the refresh window. However, this isn't the intended use of incremental refresh. The RangeStart and RangeEnd parameters should dynamically define the period for data refresh based on the current date and your specified refresh period. It's worth revisiting the configuration of these parameters and ensuring they align with your data refresh needs.

Best Regards,

Jayleny

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

[Anonymous]

Hi @leandross89 

Here are a few steps to help resolve the issue:

1. Verify Incremental Refresh Configuration: Ensure that the incremental refresh is correctly configured for the "Apn" table, which is the result of the append query. This includes setting up the RangeStart and RangeEnd parameters within the Power Query for this specific table. For more details on configuring incremental refresh, please refer to the official documentation Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft....
   
   

2. Check Data Source and Query: Since you're working with CSV files, ensure that the data source for the current day's data is accessible and correctly referenced in your Power BI Desktop file. Additionally, verify that the Power Query used to append the tables correctly includes all necessary data.
   
   
   
   
   

Best Regards,

Jayleny

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