Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental Refresh on PowerBI Web not Working

Hi,

I have a report with 3 tables from the same source (SQL Server) in which I want to apply the incremental refresh feature.

I used this article in order to properly setup this feature: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

The configuration for the 3 tables were like this:

 

RangeStart, RangeEnd end date filtering

The time span I needed was to maintain data for 5 years and increment daily.

Incremental Refresh Configuration

 

After that I published the report on PowerBI Web (I use PowerBI Pro) and used this scheduled refresh configuration.

Refresh Schedule


It all seemed fine but when I went to check the next day if the report was updated I noticed that it hadn't. Even after I refreshed manually the data from the previous day didn't appear on the report.

I'm new to this forum so if there's some information missing just ask me that I update this post with it!

 

I really need some help to set this feature up, so if you can help I already thank you!

 

PS: I don't know if this has to do with this problem, but in the table 'Tempo Medio' I had to convert the date column from date to datetime directly on PowerBI because I couldn't change it directly on the database. If this is a problem, I don't get why the other tables didn't update, not just this one.

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    Hi  Anonymous ,

    Have you configure incremental refresh settings  on the power bi  service?

     

    You can see the article below,it tells details about configure Incremental Refresh for SQL:

    Power BI Incremental Refresh for SQL Sources

     

    Wish it is helpful for you!

    Best Regards

    Lucien Wang

  • Anonymous's avatar
    Anonymous
    Not applicable

    It worked perfectly!
    Thank you so much!