Hi Aye,
What do you mean you're copying data to excel?
By default, any query will load results to sheets. You can change that by right clicking the query-Load To, in this menu you can choose to load to sheet, to data model.

Hi Aye,

The Power Query editor window only shows the first 999 records. This is only a preview of the data and allows Power Query to be more responsive as you work through the steps to clean and transform your data. Once you press 'Close & Load' it loads the entire data set, resulting from the steps you applied, to the workbook or data model or connection as set in the 'Load to' settings.

If there are only 1000 records being loaded, then either the source is throttling the data e.g. APIs often limit the number of records they'll deliver to Power Query. e.g. From memory, SalesForce's API will only return 2000 records.

The other possibility is that the applied steps have resulted in the data being filtered in such a way that there are only 1000 records that meet the criteria.

Mynda

Thanks, Mynda and Catalin.

Hi Catalin,

My data are started from Power BI, so that sometimes, I wanted to view in excel copy them from PQ make down to 1000 lines.

Thanks Mynda,

I now realised I can get the copy of all data from power BI too.

Regards,

Aye