Visual With Direct Query Works in One Page But Not Another Page

Anonymous amitchandak  Thanks for your responses, I think I've been able to work around it, I did not notice there was a filter on my first page where it worked, although the filter did not filter that much out. However, with this applied my belief is that it's created a WHERE clause in the SQL PBI used to get the data that did not pull everything. I have not had time to troubleshoot it at the backend, but my belief is the raw sql was pulling more data than was required hence exception, by applying the filter to the page or visual the problem went away.