Forum Discussion

raymondwkmok's avatar
raymondwkmok
Frequent Visitor
4 years ago
Solved

Incorrect Time Zone setting at Power BI Service

Hi there, it’s related to time zone issue. I’ve made the necessary setting at the Power BI Desktop that shows the time correctly in the desktop version at UTC+8:00.   The report at Power BI Service...
Need Help
Jays_D's avatar
Jays_D
Advocate II
2 years ago

The fact that this is still an issue in Power BI is absolutely laughable.

We have a report that was built in PBI Desktop, highly complex (has over 60 date & time columns + multiple calculated columns off the back of them) and only realised this was an issue once it was published to service and the dashboard went through it's first refresh - minusing 10 hours as the data is in AEST.

If there was a way to solve for this (i.e. apply a blanket rule you could apply aross all date & time columns  in the dashboard to compensate the time difference) we would implement and continue with Power BI in our organisation, but to be told by Microsoft Support "just make a new calculated column for each" and "there is no other way" is utterly ridiculous response/resolution for an already data-intensive dashboard.

I sincerely hope Microsoft sees this and considers doing something about it. If my data in Dynamic365 is captured and presented correctly, it should be presenetd THE SAME when fed through PBI service - it is illogical to change the value from what it is/intended to be.

This specific case is now the basis of a discussion in our organisation of over 40,000 employees to move away from Power Platform (PBI specifically) back to Tableau as this was not an issue we faced using the same data sets. If an application captures data as:

02/11/2023 - 3:00pm

It should be presented as such, not manipulated, not require a custome column etc - it is a raw value which should be presenetd accordingly.

afiqhaziq's avatar
afiqhaziq
Frequent Visitor
2 years ago

Do we have a solution for this now? Im still having trouble with this issue. All the data from my sharepointlist need to plus by 1 in power BI and with a lot of data it can get very confusing 

  • paulberaud's avatar
    paulberaud
    Frequent Visitor
    1 year ago

    You can create 1 custom table with multiple columns based on platform.

     

    The core columns are:

    YEAR (add maybe the next 25 to 50 years starting with current year)
    March2ndSunday (start of DST)
    November1stSunday (end of DST)

    Then you add extra columns you need such as the ones below with an if statement to capture the date if they are in or outside of DST and adjust UTC+(#):
    PowerBiService_col
    DST_col
    Sharepoint_col
    Somesite_col
    etc...

    It's definitely an extra step, but well worth it. Once setup, you already have the years and DST accounted for so you are just adding columns and adjusting the if statement as needed so you just set it and forget it.