cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anandmitta
Helper I
Helper I

Manual Refresh showing data till last scheduled refresh time

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?

 

 

2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

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

anandmitta_0-1643094944887.png

 

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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

vyalanwumsft_0-1643005397288.png

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
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

anandmitta_0-1643094944887.png

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors