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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Aswinraj
Frequent Visitor

DateTime Zone switch automatically (JSON Input)

Hello All,

 

I Imported JSON Script into PowerBI and built a report long back. But suddenly the Date Column Changed from UTC to IST.

Date format in JSON Script is 2023-01-23T19:47:14.3830000 -> Which is 1/23/2023 7:47 PM ( in UTC).

Suddenly from yesterday, the Date is showing as 1/24/2023 1:17 AM ( in IST) and the underlying JSON shows as 2023-01-23T19:47:14.3830000. 

But in Input File still the JSON Script is 2023-01-23T19:47:14.3830000.

 

Any idea on what causes this issue.

 

Incorrect format which suddenly appears.

Aswinraj_2-1681275157925.png

Aswinraj_3-1681275169534.png

 

Correct format which is present in JSON Script

Aswinraj_4-1681275197829.png

Aswinraj_5-1681275212267.png

 

 

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.