sharepoint import - Date field

[udhaiya]

Hi,

I'm trying to import the Date field from SharePoint Online to Power BI .I could see the Date field is one day less than the value displayed in SharePoint. Is there a way to sort this issue ?

I think it's somthing to do with Day light Saving. I am worried to include a custom column in Power BI as it would have advers effect during the Day light saving. I am based out of UK region.

Your help is really appreciated. Since I am new to Power BI reports would be good, if you could help with the steps in details.

Thanks!

[udhaiya]

I was able to fix this issue. By converting DateTime field to the corresponding TimeZone. Thanks

[v-yuezhe-msft]

@udhaiya,

Please change  the ApiVersion to 14 in the Advanced Editor of your query.


If the above step doesn't work, please add a custom column to convert date to your time zone following the guide in the similar blogs below.

http://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.c5insight.com/Resources/Blog/tabid/88/entryid/121/gotchas-when-using-power-query-to-retr...


Regards,
Lydia

[Greg_Deckler]

That sounds odd. You can edit your query to add days or time or whatever, but that sounds weird.