Forum Discussion
sharepoint import - Date field
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 ? ...
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-retrieve-dynamics-crm-data-part-1.aspx
Regards,
Lydia