Forum Discussion

dcarreropi's avatar
dcarreropi
Frequent Visitor
3 years ago

PowerBI not exporting datetimezone correctly

Hello,    I have a sharepoint list which is already set up with the right time zone, also my desktop app is set-up with the correct time zone. However when I transfer the data from SharePoint to Po...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Something doesn't compute here.  7:00 am +2 is 5:00 am UTC, not 9:00 am.

 

Please explain your setup in more detail.

dcarreropi's avatar
dcarreropi
Frequent Visitor
3 years ago

Hi Ibendlin, 

 

Exactly it doesn't compute and that's my issue. It should be 9 am and when it translate to PowerBi from Sharepoint it appears as 7 am, while exporting it to Excel get 9 am which is correct. Not sure why PowerBi is doing this. The Sharepoint has the correct time zone which is the same as the powerbi and excel and just powerBi doesn't get it right. 

 

Thanks 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    The basis for the Power BI Service is UTC.  The report rendering will be adjusted based on the timezone information in the users'  browser.