Incremental Refresh on PowerBI Web not Working

[Anonymous]

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.

[Anonymous]

It worked perfectly!
Thank you so much!

[v-luwang-msft · Accepted solution]

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