Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to Test if Incremental Refresh is Working?

I've set up incremental refresh on a dashboard linking to Athena data source. It refreshes and looks fine, but takes a little longer to refresh than the same report without incremental refresh on (wh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?

pthapa's avatar
pthapa
Icon for Post Patron rankPost Patron
2 years ago

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's avatar
    ctmullins
    Icon for Advocate II rankAdvocate II
    1 year ago

    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.