Is this a Live connection?
Are you employing any filters?
What is the common thread or denominator of the missing list items? This could be a clue as to why they are not being imported.
ODATA connections are extracts
I don't apply any filters.
Items don't have a common thread or anything similar.
When I use excel as middle layer I do see all 741 items in Tableau...
I also cleared all caches, no luck...
I use other SharePoint lists the same way and it works perfect...with this one it doesn't :\
Okay, just checking for the obvious. I know OData needs extracts but some people don't because they refuse to read the manual.
Could it be a list permission issue?
1. thanks Toby for your time!
No, I checked the permissions. I have full control and in the browser I do see the missing rows in the list and also in the XML .
Okay, it sounds like you know what you're doing and I'm out of ideas . My only guess would be something in the workbook is filtering out the results. Are you using a distinct count in the Number of Records mark?
Have you tried displaying all of the rows and then exporting those full results to see if there are duplicates? Does the data have a unique key/ID that you can check against the source data, figure out what rows are not displaying?
Hmm...I guess I did have a couple ideas
no duplicates and number of records is also not using a distinct count (it is the default number of records calc.).
In my datasource I figured out what items are not imported but I can't see any reason why Tableau refuses to import them...
Unless someone else chimes in my only suggestion now is to contact Tableau Support to see what help they could offer.
1 of 1 people found this helpful
Did so Toby,
and I did not expect that answer but they said connection to SharePoint List via ODATA is not supported...
My "bug" seems to be one of the reasons why it is not supported.
Further, I think they just don't have the possibilities to debug this because I can't grant them access to the data so they are not able to reproduce it.
Anyway, thank you for your help Toby, I really appreciate it.
Yes, OData is an odd duck! Some people can connect but it's not always consistent. When SharePoint changed in version 2013 it really screwed things up for us as well
Thanks for letting us know what support told you