Forum Discussion
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.
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
2 Replies
- v-luwang-msftCommunity 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
- AnonymousNot applicable
It worked perfectly!
Thank you so much!