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