Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
AdamWhittaker
Helper I
Helper I

Incorrect time - Console log tableDataView

Hello,

I am trying to correctly display datetimes in a custom visual but the time is always off.

I am going from Salesforce > MS SQL > Power BI > Customer Visual

 

The time comes out of Salesforce in UTC, then in SQL Server it looks like this  (which is still in UTC - my local time at the time was 11:56):

 

SQL Server DataTime: 2024-10-25 15:56:00.000
SQL Server DateTimeOffset: 2024-10-25 15:56:00.0000000 +00:00

 

In a table visual (which looks good for UTC):
In a table visual: Fri, 25 Oct 2024 15:56:00

 

But then logging the tableDataView it shows this:
Console log (SQL Server DataTime): "2024-10-25T19:56:00.000Z"
Console log (SQL Server DateTimeOffset): "2024-10-25T19:56:00.000Z"

 

Why would it jump 4 hours ahead? If it was going to change it I would have assumed it would change it to local time which would have been -4 hours.

 

I tried both building the visual and testing local time to avoid any issues with local testing and the PBI service but both locally and debugging on the service have the same times.

 

Any ideas?


Thanks,

6 REPLIES 6
AdamWhittaker
Helper I
Helper I

I guess my only option is to bring them through as strings and let JS do the conversion?

Can you create a view in your SQL Server that presents these timestamps in the proper ISO-8601 format?

Maybe, what does power bi want though? Power bi itself shows the correct time (if i put it in a table or matrix etc its good), its only converting the date/time (+4 hours) when being sent to a custom visual and its not the visual since i am logging the datatable before i even touch it in there? Is there something in the pbiviz code doing the change? (which is why i was thinking just sending it as a string would be easier, but i am still curious to why its changing it)

The problem is that Power Query understands timezones but Power BI does not. On top of that the Power BI service is running on UTC.

 

It's a very old  (pardon the pun) problem.  Solving DAX Time Zone Issue in Power BI - RADACAD

lbendlin
Super User
Super User

Instead of datetime use datetimezone in Power Query.

I am in direct query mode and it won't allow that:

 

AdamWhittaker_0-1729892882396.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Top Solution Authors