How to change the time zone of PowerBI in desktop?

[Jenny_Zhang]

I have a dashboard made in PowerBI desktop and the source data is Salesforce. I see the dates from the source are showing as a different timezone compared to Salesforce. I tried to change the locale but did not work. I also tried to use Power Query to change the timezone but did not work either. Is there an easy way to update all dates to a different timezone? Thanks

[KaiPonte]

Still wasn't sure how to do this after reading the comments. I just edited teh SQL query. The server in our instance is eight hours ahead of us, so I just correct for that in the query directly. Not the most elaborate, but it works.  Here's one line. It subtracts eight hours to make it our time zone...

TO_CHAR(DATEADD(hour, -8, u.current_sign_in_at), 'YYYY-MM-DD HH24:MI') AS "Most Recent Login",

[PiEye]

Hi Jenny

Have you tried "making" the timestamps a timestamp-zone? 

This function in M query will do the trick:-

DateTime.AddZone([datetime],-7)

Once the zone is defined in the data, you can then change it to what you need. Applying Switchzone changes the time to a different region:

DateTimeZone.SwitchZone([Added Zone],+2)

The result:

HTH 

Pi

[Sahir_Maharaj]

Hello @Jenny_Zhang,

You can easily update all dates to a different timezone in Power BI by using the Time Zone (TODatetimeZone) function.

1. Open the Power Query Editor by clicking on "Transform Data" in the Home tab of the Power BI Desktop ribbon. Select the date column you want to update.

2. Click on the "Add Column" tab in the ribbon and select "Custom Column".

3. In the "Custom Column" dialog box, enter a name for the new column and the following formula, replacing "oldTimeZone" and "newTimeZone" with the appropriate time zones for your data:

TODatetimeZone([DateColumn], "oldTimeZone", "newTimeZone")

4. Click "OK" to create the new column. If you want to replace the original date column with the new one, right-click on the new column and select "Replace Current". Click "Close & Apply" to save your changes and update your dashboard.

Should you require further assistance, please do not hesitate to reach out.

[noswals65]

I attempted these steps within my Direct Query table.  Error: 'This step is not supported in DirectQuery mode. Switch all tables to Import mode'.   Of course, Import mode removes the 'real time data' view, thus unable to switch.