Forum Discussion
Sharepoint List - Date Field
Hi, I got my Power BI connected with a Sharepoint List which contains employee data including some date fields. Now comes the weird thing. The sharepoint list item got e.g. a date 03/11/2008 ...
Hi cmoosbrugger,
Please share the information of the time zone for SharePoint site and the machine which has Power BI desktop run on.
In the SharePoint list, is it Date value or Date Time value? Please share the screenshots about the list data both in SharePoint and Desktop.
Best Regards,
QiuyunYu
Hi v-qiuyu-msft,
my field in sharepoint is a Date picker not a Date/time picker.
Meanwhile I found a workaround here (the post from JamesCook) which works so far but it is a bummer Power BI cannot handle this right away.
I tried to use different time zone for my site collection but this does not change anything. Power BI is always getting the time as well.
let me know if there are news nd PowerBI improved in this regards.