Read same sheet with varying lines.

[msquared9920]

I am looking for a way to have Power Query read the same spreadsheet but the spreadsheet can have a varying amount of rows each day.

For instance it may have 1,000 rows then the next day 1,400 rows. Then the next day 800 rows.

Any ideas?

Thanks,
Mike

 

[p45cal]

to have Power Query read the same spreadsheet

1. If the spreadsheet is in the same workbook as the Power Query query it can read updated Tables (proper Excel Tables, not just ranges that look like tables) and defined/named ranges. [MCode starts Excel.CurrentWorkbook()]
2. If the spreadsheet is in a different workbook from the workbook which has the query, it can see tables, defined names AND entire sheets. [MCode starts like: Excel.Workbook(File.Contents("C:\Users\Public\Documents\mySourceData.xlsx"), null, true)]

When you refresh a query it reads anew the data wherever it comes from.
If you're truly wanting to see the new data in a sheet and not in a table or a defined name, then it's best you use a query in a different workbook (no. 2 above).

 

[msquared9920]

Hey, guess I should have explained a few more things. The spreadsheet will be separate from the query and it will not have tables.

 

[p45cal]

Then point no.2 is the way to go.