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...
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.
