Direct Query Preview - Input query length exceeding the supported maximum length

I'm attempting to use the Direct Query preview feature that allows adding additional tables to an exsiting dataset and relating them. When I connect a new table to an existing table the report works ...