Incremental Refresh is not working in Production workspace

Question

I have a report with incremental refresh and published it to test and then deployed in Prod workspace using deployment pipeline. I have scheduled the reports weekly once in test and prod. Full load is completed in both the environments. Scheduled incremental refresh also done in both the environments. But I can see the latest data in test and could see the number of records fetched usig SSMS. But in Prod even though refresh history shows it as completed, it didn't load any of the records. May I know the reason behind this?

I did manual refresh for last 1 week using SSMS then it worked. But why the scheduled one is not working in Prod.

Anonymous

pallavi_r · Answer

Hi&nbsp;Anonymous&nbsp;,As&nbsp;lbendlin&nbsp;has mentioned, your partitions are very small. Set it to Monthly.Couple of other checks:1. Is query folding happening? you can check this by right clicking on the dataset. view native query will be enabled.2.The data parameter for range start and range end should not be same as detect data changes date.3.If all these are correct, then do a full refresh with less data. You can utilize view with date range for the same&nbsp;4.Once full refresh is done, do partition wise refresh using process data.5.Precess Recalc&nbsp;6.When you achieve success till step 5, these are step by step process. then try incremental refresh it should work.Thanks,Pallavi

lbendlin · Answer

when you set up incremental refresh you can decide which partitions to use. Something like&nbsp;
&nbsp;
"keep last 5 years and refresh last 1 months"

lbendlin · Answer

When you set the refresh policy to "automatic"&nbsp; then Power BI Service will decide by itself if it wants to refresh a particular partition or not. If there was no data change (or the service didn't catch it) then "automatic"&nbsp; may not do anything.&nbsp; Switch to "full"&nbsp; to force a refresh.