Forum Discussion
Skilled SharerWrong input in a field Date
What is the DateTime format supported by Power BI to push data in that column?
Skilled SharerThank for your message.
The problem arose last May had two variable: the first one my poor knowledge at the beginning, the second one a behaviour the MS support has defined "by design of Sharepoint".
Now I solved temporary the problem using a workaround suggested by MS tech support.
It consist to add some code in the query that trasform properly the field Date manually inserted in the Sharepoint list.
Hi gpiero,
Can you share your solution? I'm facing the same issue importing dates from Sharepoint lists. Both are DateTime columns, but I've 1 day difference like you.
- gpiero
Hi Anonymous
during the last months I tried several solutions, included the workaround proposed by MS Support.
I would like to share the last solution I found. I think it is the best one because you do not need to add a calculated column to your data.
I changed data connection on all my PBI report using the option ODATA feed from Get Data.
Source = SharePoint.Tables("https://MyCompany.sharepoint.com/sites/Wmsh/en/wkfmgt", [ApiVersion = 15]), #"9a424f75-b565-498f-a57f-220da7d75fdf" = Source{[Id="9a424f75-b565-498f-a57f-220da7d75fdf"]}[Items],Here you will find the right value for your Datetime column.
Here the string to connect to the site the contains your Sharepoint list.
https://MyCompany.sharepoint.com/sites/Wmsh/en/WkfMgt/_vti_bin/listdata.svc
Regards
gpiero