Forum Discussion
Power Query only returning 500,000 rows of data into excel
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.
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.
