Forum Discussion
Dates import as Null while Querying from Sharepoint folder
I connect to the folder then do a transform in order to navigate to the specific table.
https://<your company>.sharepoint.com/teams/<your site>
Community SupportHi mkeeping,
So may I know how is your issue going currently? If your issue is solved please mark the appropriate answer as Mark as answer. This will help other members to find a solution if they face the same issue. If you still have any questions, please feel free to ask.
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.
The issue is still not resolved. I cannot connect to using the web connector as I get an error that indicates "access to the resource is forbidden".
I can connect via Sharepoint folder but the all of the dates in the table still show up as null.
- dax
Hi mkeeping,
When you connect by web, you could get folder path like below(open file in app, the copy the path from Excel, and remove ?web=1 in path), then it should work
In addition, you said that the data in Excel will return null, you could see whether there is other chart or pivot table in it which might cause problem. You could try the sample(just have the data in it) to see whether it work or not.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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