Manual Refresh showing data till last scheduled refresh time

[anandmitta]

Hi,

I have a report on my premim workspace and I have set a scheduled refresh everyday 12 AM.

I have tried a manual refresh next day afternoon but it still shows the data till the time scheduled refresh was scheduled.

Eg: I have data in my report till 17th january 11:59 PM(Scheduled refresh 18th Jan 12:00 AM). For some reason the data didn't get update even after the refresh was successful on 19th Jan 12:00 AM. So I tried to do a manual refresh on 19th Jan 7:30 PM. The manual refresh was successful but the data was updated only till 18th Jan 11:59 PM. I didn't get the 19th Jan data irrespective of doing a on demand refresh on 19th Jan 7:30 PM.

My question is: Even if we perform an on demand refresh, will the data be updated only till the last scheduled refresh time?

[GilbertQ · Accepted solution]

Hi @anandmitta 

Are you using any of the functions to get a date/time, if you are they are all based in UTC so that could be why this is happening?

[v-yalanwu-msft]

Hi, @anandmitta ；

What’s your data connection mode (import, direct query or live connect)?

If you use direct query or live connect, manual refresh only refreshes the tiles on the dashboard.

Therefore, I suggest you to go to your dataset setting to check the refresh history. If it displays “Refresh failed”, please show me more information about your connection mode and error info.

More info about refresh in powerbi

In general, the last refresh time and data should be time-related, not related to scheduled refreshes and manual refreshes.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi @anandmitta 

Are you using any of the functions to get a date/time, if you are they are all based in UTC so that could be why this is happening?

[anandmitta · Accepted solution]

I was using a function to filter the last 90 days data (Date.isinPreviousNdays). I found that the function doesn't include the current day data. I have added the below condition as well to the filter and now it's working fine