Power query not picking up extra data in Excel table.

[farmerscott]

Hi Everybody,

I am using Excel 365.

On a sheet I have a table that I add data to. When I look at its dimensions, it increases as data is added.

However, my query within power query does not pick up the extra rows. The query is based upon the table not the sheet.

Manual refreshing does update any new rows.

My table is 160 rows by 9 cols, so I am sure I am no maxing out Excel's capabilities.

Any ideas?

thanks,

 

[JEC]

It needs a refresh like you describe

 

[farmerscott]

Hi JC,

unfortunately a refresh does not pick up the extra data.

thx.

 

[JEC]

You said it did

Manual refreshing does update any new rows.

 

[RoryA]

What's the query code?

 

[farmerscott]

What's the query code?

Hi RoryA,

Here is the first step in the "Applied Steps". It is pointing to the right file.

= Excel.Workbook(File.Contents("C:\Users\agreenep\Documents\Scott\Ravensworth\Ravensworth Cotton 2024.xlsx"), null, true)

and then I have as the next step, which looks OK.

= Source{[Item="TruckingData",Kind="Table"]}[Data]

All other code I have is about manipulating the data.

Hope that helps.

 

[RoryA]

So your query is in a different file? Are you certain that the additional rows are in fact part of that table, and that the source workbook has been saved?

 

[farmerscott]

RoryA,

1. The query and the data are in the same file.

2. Yes, I have saved the file and done a refresh but nothing changes.

3. When I check, the table has expanded (from new data) via "Name Manager", it shows the right dimensions of the table.

Hope that helps.

 

[RoryA]

If they are in the same file, why aren't you using Excel.CurrentWorkbook?

 

[farmerscott]

If they are in the same file, why aren't you using Excel.CurrentWorkbook?

That was the code generated by power query.