Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pete_2016
Regular Visitor

Data refresh in overrides local time

‎10-31-2016 07:30 AM

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

Message 1 of 3
734 Views
0
1 ACCEPTED SOLUTION
v-micsh-msft
Microsoft Employee
Microsoft Employee

‎11-01-2016 10:35 PM

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

View solution in original post

Message 2 of 3
949 Views
0
2 REPLIES 2
v-micsh-msft
Microsoft Employee
Microsoft Employee

‎11-01-2016 10:35 PM

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

Message 2 of 3
950 Views
0
Pete_2016
Regular Visitor
In response to v-micsh-msft

‎11-02-2016 07:59 AM

Thanks, Michael.

Just gave my vote, hope that the improvment takes place soon.

 

Regards, Pete

Message 3 of 3
705 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

View All