Dear All,I've been facing issue with date value from sharepoint. When Using the sharepoint list as source and loading in to power bi, Dates are getting changed while loading itself. For example, if a date is 07/01/2019 in SharePoint, its getting loaded into Power BI Edit Query as 06/30/2019. This is happening for all the dates in power bi. Please hepl me on this .Have given the issue and the known details below, Source - SharePointColumn Datatype in SharePoint - Date Edit Query Power BI The same data is getting changed in both the fields Due_date & VR Date. Please do let me know what might the root cause for the issue. I have tried changing the Timezone, Adding TimeZone, Adding hours but seems nothing to work. I am not able to understand why the dates is getting changed in power bi. Kindly help.Zubair_Muhammad , Cmcmahan , jdbuchanan71

Hi DouweMeer ,this issue is due to the Version Change in the API for accessing the Data from the Sharepoint to Power BI. Have raised an ticked and got it solved. Based on the solution provided, i changed the API version for the sharepoint source in Advanced editor from 15 to 14. This took in the actual data from sharepoint instead of converting into Text and changing the date into localetime. Adding this solution for any queries related to this kind of data load issue from sharepoint. Regards,Praveen

SharePoint Date Data getting changed in Power BI

Forum Discussion

Related content

Need help getting a percentage change working

Sharepoint list mirroring

Mirrored SharePoint List (Preview) - “Failed to get document libraries” Error 404

Unable to get data from sharepoint folder

Extract Data from sharepoint