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
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

Chandra_maha's avatar
Chandra_maha
Icon for Helper I rankHelper I
3 years ago

Hi,

 

I am facing the same issue. Could you please let me know where to add this source information with steps. This would be really helpful.