Your source sheet may be too large to be transferred. By applying a query, you can only select column A to see if that transfer succeeds to confirm that your sheet is too large.
- Edit or create a connection
- Open the filter setting
- Choose Query
- Use the query statement "SELECT A"