Forum Discussion
Dates import as Null while Querying from Sharepoint folder
Community SupportHi mkeeping,
If possible, could you please inform me how you connect to sharepoint folder? When you connect to sharepoint folder , you need to use URL like below
https://<your company>.sharepoint.com/teams/<your site>
Or you also could try to connect to it by web like below
https://<your company>.sharepoint.com/teams/<your site>/Shared%20Documents/Book3.xlsx
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.
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>
- dax
Hi 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 ZhiIf 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.