Power Query only returning 500,000 rows of data into excel

Copper Contributor

I have a Power Query that connects to an Azure Log Analytics workspace pulling back data which I then populate an excel spreadsheet with, and generate graphs and pivot tables.


I have just noticed that the records returned into Excel caps out at 500,000 records, and I know that there are more than 500,000 records.


Is there a limit? I can't figure out if it's my query, or something else.



1 Reply

@Nitecon Excel takes just over a million rows so I doubt it's an Excel issue. But why load 500K rows to Excel and then produce pivot tables and graphs? You load to a pivot table/chart directly from PQ. Or load the table to the Data Model and work from there.