10 Jun’15

BIResolving Time Zone Issue in PowerPivot

Key Technologies: Power BI, PowerPivot, Business Intelligence

Note: This article assumes experience on PowerPivot for Excel 2013/2010

Many a time data needs to be imported and processed from systems belonging to different locations and hence having different time zone. For example, consider the following scenario.

A user residing in India having IST time zone might need to import data into PowerPivot model from CRM Online System having CEST as time zone required for Power BI Dashboards or for performing Data Analysis. There might be critical business data related to revenue or sales that matters the most. If date time is not properly converted or processed, end user might see incorrect output. When working with PowerPivot, after importing data into model, new calculated columns needs to be created before working on revenue reports or any business related critical data so that proper reports/results are displayed to end user.

Here, we are converting to match data for CEST time zone. Similarly for other time zone, we can add/subtract UTC offset as shown below:

Central European Summer Time (CEST). Offset UTC +2:00 hours

Eastern Standard Time (EST). Offset UTC -5:00 hours

Central Standard Time (CST). Offset UTC -6:00 hours

Mountain Standard Time (MST). Offset UTC -7:00 hours

Pacific Daylight Time (PDT). Offset UTC -7:00 hours

Written by

Team Member


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more