Forum Discussion

muskagap's avatar
muskagap
New Member
1 year ago

Values change only after adding ModificationDate column (Incremental Refresh)

Hi, I use Incremental Refresh in my PBI report. SQL table is my data source. There's an extra ModificationDate column on that table to indicate which rows have change over last 3 months.  Now, I go...
Need Help
Show and Tell
pallavi_r's avatar
pallavi_r
Super User
1 year ago

Hi muskagap ,

Can you please ensure the below 2 items are taken care for incremental refresh to work effectively.

i)  the data parameter which is used for filteration of data model using rangeStart and rangeEnd should be different from column used in Data Detect Changes.

I was facing this issue when I was using the same date column for filtering rangestart, rangeend and detect data changes.

ii)Ensure query folding is happening by right clicking power query step and check for view native query enabled. Sometimes due to data type mismatch from source and destination, query folding does not work.

 

More details @ https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

 

Thanks,

Pallavi

muskagap's avatar
muskagap
New Member
1 year ago

Hi pallavi_r ,

 

thank you for your reply. Actually, for your both questions the answer is yes. Data column is different and query folding works. I've read that detecting works on automatic refresh, however it may not work if your refresh data manually. F5 come sin handy then. In real scenario I would be using automatic refresh instead of manual one so most likely my problem will vanish, however I was just curious about manual refresh.