Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

SharePoint to Excel Invalid Date time values

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 Sharep...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.