This seems too simple an answer, so I apologise if I’ve misjudged it, but if you’re using the Data Explorer Plugin the posts are in the posts table, and the drafts in the drafts table.
Is there an error in your browser console that can add some extra detail to what’s not working?