Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
7 years ago

Analyze in Excel Returning Wrong Time Zone

Hello, I am creating a data model to be used strictly as Analyze in excel. I have added a table with the current date time. It is correct in Power BI Power Query, but when I bring in the same field i...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi jpt1228 ,

I still have a little confused about your scenario.

What the Analyze in excel do you mean? Do you mean the feature  Analyze in excel in Power BI Service?

If it is, I cannot reproduce your issue by my tests.

In addtion, will you have this issue in Power BI Service?

If not, please describe your scenario in more details.

Best Regards,

Cherry

 

  • jpt1228's avatar
    jpt1228
    Icon for Responsive Resident rankResponsive Resident
    7 years ago

    Hello v-piga-msft  Yes - the Analyze in Excel feature in Power BI service. I am in Mountain time zone and I believe when I use the analyze in excel option it is returning GMT time zone without the correction.

     

    As shown in the original post the local time is returning as correct. When I use the analyze in Excel feature in the Power BI service it returns the time shown in Power BI report (as a check) +6 hours.

     

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi jpt1228 ,

      By my tests, I cannot reproduce your issue.

      Please check the time in power bi service is the same as your system timezone which installed Analyze in Excel.

      You could find the timezone in power bi service like below.

      Normally, the timezone in power bi service should sync with the system timezone.

      Best  Regards,

      Cherry

       

      • jpt1228's avatar
        jpt1228
        Icon for Responsive Resident rankResponsive Resident
        7 years ago

        Hello v-piga-msft  the time zone is correct in Power BI desktop and service, but incorrect when I build a report using anayze in excel.

         

        When I refresh Power BI desktop and power bi service I get one time, when I refresh the analyze in excel file tied to the data model it returns a different time zone. It is different by 6 hours.