Forum Discussion
SharePoint Date Data getting changed in Power BI
- Anonymous7 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
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
Hello,
I have the same issue with dates but I am Power BI begineer and do not know where I can change the API code that is presented here.
Would you be so kind and tell me where and how I can do it?
Regards,
Mat