Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.