Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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