SharePoint to Excel Invalid Date time values

[Syndicate_Admin]

I created a PowerApps using SharePoint List as the data source.

Now I am trying to generate an Excel report using that data. When I am using Get Data From Online service (in excel) and select Sharepoint I can get all the list data into my excel file.

But in Excel it shows the wrong dates and times. (10 hours less).

  

Checked the regional settings in both Excel and Sharepoint.

Both are in English (Australia). SharePoint shows the correct dates and times. All I need is to get the same dates and times into Excel to generate some reports.

  

Can someone direct me to get the correct date and time into Excel from SharePoint.

Thank you

[Anonymous · Accepted solution]

Hi @Naviya89,

I suspect it might be because of that:

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
If not, please check that your browser's time zone and your computer's time zone are both in Australia.
And please Ensure that both SharePoint and Excel account for any Daylight Saving Time changes if applicable to your region.
If none of these methods work, use a formula in Excel to add the time difference. For example, if your SharePoint data is in UTC and you are in UTC+10, you would add 10 hours to the SharePoint time value.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.