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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ashishrj
Power Participant
Power Participant

Dealing with timezone issues while importing data from remote server

I was working for a client in Amsterdam and was facing timezone issue which was reflected in reports. For eg. revenue for a particular month/year was not properly shown. After several methods and research, I was successfully able to resolve it by simply creating a new calculated column.

New_Calculated_Date= Old_Calculated_Date + 2/24 (where 2/24 is used for conversion)

And later I was able to properly view data.

Any other method/technique to deal with timezone issue in Power BI?

 

1 ACCEPTED SOLUTION
andre
Memorable Member
Memorable Member

This is really interesting, i have not really thought about time zone issues with the service, are you saying that all your calculations assume that they are located in the Pacific time zone? 

 

Basically, we need to have a capability to determine what time zone the user is in and adjust the calculations to reflect it properly...

View solution in original post

3 REPLIES 3
elliotdixon
Responsive Resident
Responsive Resident

Hi @ashishrj seems I spoke too soon. Tried applying the calculation to the date columns in a few different points and worked it out. Cheers for your info about this fix.

elliotdixon
Responsive Resident
Responsive Resident

Hi @ashishrj Can you tell me how you did this.

I have tried your process a few different ways. For me its (13/24) as I am in New Zealand +13 hours. But I cant get the right daily totals to show on PowerBI online. Everything looks fine in the Desktop app but when uploaded the totals don't match till 1pm (+13 hours).

 

Where did you apply the calcuated column? In a Date Table or in the actual data table?

 

Cheers

ED

andre
Memorable Member
Memorable Member

This is really interesting, i have not really thought about time zone issues with the service, are you saying that all your calculations assume that they are located in the Pacific time zone? 

 

Basically, we need to have a capability to determine what time zone the user is in and adjust the calculations to reflect it properly...

Helpful resources

Announcements
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!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.