sharepoint import - Date field

Question

Hi,&nbsp;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 ?&nbsp;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.&nbsp;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.&nbsp;Thanks!

greg_deckler · Answer

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

anonymous · Answer

udhaiya,
Please change&nbsp; 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-retrieve-dynamics-crm-data-part-1.aspx    Regards, Lydia

udhaiya · Answer

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

Forum Discussion

sharepoint import - Date field

3 Replies

Related content

Sharepoint List Importing Problems

Importing a Lookup Field

Import from OneDrive and SharePoint greyed out

Importing Multiple Lines of Text field from SharePoint list

Converting Epoch Date fields within the import statement