Exports in a .csv format from Data Query are limited to 200 000 rows by default.
An option to increase the limit to 1 000 000 rows exists.
The API is also limited to 200 000 rows.
You can, if needed, export more than 200 000 rows by cutting your analysis period in several smaller periods.
However, there are tools dedicated to massive data exports, such as:
- DataFlow2: https://support.piano.io/hc/en-us/articles/4465953880594-Introduction-Data-Schema.
- Data Sharing: https://support.piano.io/hc/en-us/articles/8275302406930-Introduction-Data-Schema-Access.
These two tools are a paid option.
Feel free to contact your Account manager or our Support Centre should you need any further information on these options.