Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have created dataset from CRM online cases database using Power BI Desktop to analyze the hourly inbound of cases. The CRM Online data includes only UTC 0 time zone which I needed to convert to local time. All works fine if I refresh data in Power BI Desktop and also after publishing it to Power Bi first the time was local hour. But after the first scheduled data refresh time was overridden to UTC 0. Is there a solution to prevent this?
Thanks,
Pete
Solved! Go to Solution.
Hi Pete_2016,
Well yes, currently the time in Power BI Desktop and Power BI service can't be synced, as the service would convert the time to UTC.
There is an idea submitted on this part already:
Support for visualization of UTC timestamps
Please vote for it if this is the feature that you would Power BI to have in the furture.
Besides, Ken Puls shared a blog which could be a workaround to display the time rightly in the service, check to see if the blog would help:
Display Last Refreshed Date in Power BI
If you need any further assistance on this topic, please post back.
Regards
Hi Pete_2016,
Well yes, currently the time in Power BI Desktop and Power BI service can't be synced, as the service would convert the time to UTC.
There is an idea submitted on this part already:
Support for visualization of UTC timestamps
Please vote for it if this is the feature that you would Power BI to have in the furture.
Besides, Ken Puls shared a blog which could be a workaround to display the time rightly in the service, check to see if the blog would help:
Display Last Refreshed Date in Power BI
If you need any further assistance on this topic, please post back.
Regards
Thanks, Michael.
Just gave my vote, hope that the improvment takes place soon.
Regards, Pete
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.