Upon looking deeper at what the query was pulling we found a DB view that our userID was not given access too. This solved the issue!