Download to Excel - "Refusing to run query with no limit that Looker cannot stream incrementally."

I regularly download data from a Look (Excel format, With visualization options applied, Formatted, All Results).

In the last few days, rather than the expected data, this message is provided in the spreadsheet:  Refusing to run query with no limit that Looker cannot stream incrementally. Please choose a smaller limit or remove table calculations.

I’ve decreased the Row Limit from 500 to 250 to 100 to 25 to 24 (the exact number of data rows for a particular download), and still receive this message.  Another data set had just one data row, and with a Row Limit of 1, still garnered this message.

Is anyone else having this issue?  What is occurring, and how do I fix it?

Thank you!

Solved Solved
1 3 1,524
1 ACCEPTED SOLUTION

The problem is the ‘all results’ as part of the selection. You have to define results in the download, and say how many rows to download (500, 1,000 etc).

View solution in original post

3 REPLIES 3
Top Labels in this Space