Analyze in Excel Returning Wrong Time Zone

[jpt1228]

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 in the Excel OLAP CUBE it is the wrong time zone.

This is my formula for the table in Power Query

= #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

On the left is what it shows in Power Query, on the right is how it comes through to Excel. I need the Excel to be the same date/time as the Power Query.

Thanks

[v-piga-msft]

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]

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]

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]

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.