I have currently connected to a sharepoint list via integrated authentication on the server. Every time I refresh my extract connection no data is returned (everything is null). I have already added the tableau user id to sharepoint with read and contribute access and when I tested my connection it connects successfully. I suspect that something is wrong with the sharepoint where anyone can access the site but the lists don't show up unless you have access. What more should I do beyond adding the server ID to the groups?
I am currently connecting the sharepoint at the site level rather than the list level (which works fine on desktop. refresh also works fine on my desktop environment).
I have already looked at the using sharepoint objects as a data source ADMIN doc,