Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

Incremental refresh selective outage

I have two folders in sharepoint called f1 (receives daily files) and f2 (receives daily files)         -> folder contents of f1 (68 files) and f2 (100 files) respectively  go into datflows called ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi smpa01 

 

What I have found is that because all the Power BI Servers are using UTC for their datetime, what can sometimes happen is when the incremental refresh is running it will not include your current date. And that is why it appears to be missing the data.


To solve this I always change the incremental refresh policy to refresh the last 2 days to ensure that it always gets the data irrespective of time.

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    3 years ago

    GilbertQ  Thanks. I will try and report back.