Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SharePoint Date Data getting changed in Power BI

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

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Everyone,

 

I faced the same issue, and I did not have access to change the API version as suggested by Anonymous . I found a simple way to match the dates (Assuming you do not need exact timestamps). Apply a "End of Day" transformation in the power editor:

 

 

This deafaults it to 12AM of the original date. I hope this helps someone out there.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks! This really works! šŸ˜ƒ