Forum Discussion
Responsive ResidentAnalyze 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 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
4 Replies
v-piga-msftResident Rockstar
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
jpt1228Hello 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