Forum Discussion
jpt1228
Responsive Resident
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 i...
v-piga-msft
Resident Rockstar
Resident RockstarHi 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
jpt1228Responsive Resident
Responsive ResidentHello 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.