Forum Discussion
How to Test if Incremental Refresh is Working?
Community SupportHi Anonymous ,
You could enable the option of Detect data changes. If you have a modified DateTime (or updated DateTime) in your table, then the process of incremental refresh can monitor that field, and only get rows that their date/time is after the latest date/time in that field in the previous refresh. To enable this process, you can enable the Detect Data Changes, and then choose the modified date or update date from the table. Notice that this is different from the OrderDate or transaction date. And not all tables have such a field.
All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only
Power BI Incremental Refresh - Understanding Detect Data Changes
Thanks v-xuding-msft , I'll give that a go. The table I'm working with (at the source) only has dates in string format - I convert these into date-time format in PBI. Will this still work in that case, or is there a way I can make it work despite the difference in formats?
- v-xuding-msft
Hi Anonymous ,
Sorry for late back. You could change the data type to Date. It will work.
Have you implemented it? If yes, please accept the helpful answer as a solution. More people will benefit here. If you have any questions, please feel free to ask.
- v-xuding-msft
Hi Anonymous ,
Have you resolved it?
Not yet, no - I got pulled off onto something else. Still seeing no performance improvement in time to run and not sure why.
pthapaPost Patron
Hello Anonymous,
For incremental refresh to work, you need to have a datetime field.
If your source has string format, then change it to datetime in PBI.
Thanks,
pthapa
- ctmullins
Advocate II
That's not the answer to the question.
The question - one which I also have - is: What monitoring tools/log data do we have access to if we wish to VERIFY that the incremental refresh is indeed doing what we intend for it to do?
The "Monitor" option in the PBI Service is nearly useless.
