Wrong input in a field Date

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