Forum Discussion
incremental refresh
Hi Anonymous
You may have a look at below articles.
https://powerbi.microsoft.com/en-us/blog/incremental-refresh-in-power-bi-premium/
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
https://prologika.com/notes-on-power-bi-incremental-refresh/
Regards,
Cherie
Hi Cherie,
Thanks alot for your response.
Scenario where i am confused is i have period column which is format yyyymm, now teher multiple records for every client with this period in database.
When i do query folding i have chosen period column and applied parameters to this.
But when i select incremental refresh option in views of pbix it shows that it will "Refresh rows where column period is in the last"
Does this statement means that if this column will get updated or any new record is added then only refresh wull take place"
Or it means that complete dataset will get refreshed with updated and newly added rows as my period column wont change in case of any updation.
Do i need to do queryfolding on lastrefresh date column only ????, or doing it on period makes any difference?
Please please help!!!