1 of 1 people found this helpful
I have found the issue.
It has something to do with context filters. I was using a context filter to create a range of exclusion dates (testing period) that appeared to cause this problem. Once I started removing the filters I found this one to resolve everything. I was applying it as a global filter so all created views using that source automatically populated the filter.
So if you are having some issues with an SQL query check your filters.