Report date field is not updating but schedule refresh is working

[Pooja_Mishra]

Hi,

I have scheduled refresh a report in Power BI service and it's working but only the refresh date field is not updating.

When I download the PBIX file and try to refresh the table then it works but not automatically in Power BI service.

Can anyone halp me on this so that I do not have to this manually everytime.

[Pooja_Mishra · Accepted solution]

Hi, 

Thanks for your help.

I am able to identify the issue by myself.

The issue was caused because I was using local time function to get current refresh time, when refresh in Service, it always show old date which is expected since service use UTC timezone

Resolution:
Source = DateTimeZone.RemoveZone(DateTimeZone.UtcNow()) + #duration(0,number of hours,0,0)

in Advance editor in Transform data and publish the report 

[v-binbinyu-msft]

Hi @Pooja_Mishra ,

Normally, this shouldn't happen, could you tell me about the process you used to create the report and the actions you do on the Service.

Best regards,
Community Support Team_Binbin Yu