Forum Discussion
Dates import as Null while Querying from Sharepoint folder
I'm not sure that connecting to the file via the web is really that important for this issue as I can connect to it using Sharepoint Folder. The primary issue that I need to resolves is that the date columns show up as null and the rest of the data shows up correctly when the data comes from Sharepoint:
When I download the same xlsx file from Sharepoint and connect to it from the local copy the dates show up correctly:
Two different import behaviours on the same file.
Regards,
Max
Community SupportHi mkeeping,
This is a little strange, I test this in my environment, which work well. If you open the Excel in sharepoint, will the date field show null? In addition, if possible, could you try to share the Excel for me to test this (grant me the permission to the Excel (you could use a sample instead of real data) in your sharepoint site, then I will try to test this in my environment).
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.