Power Query from External workbook is not creating Table with QueryTable inside|VBA & Macros|Excel Forum|My Online Training Hub

Hi Guys,

i am using Data--?from other sourcers --> Workbook to get few listobjects from Excel workbook. 

After setting connection i am using Load to --> existing worksheet --> and showing range A1. 

And now instead of creating Listobject with QueryTable power query is creating listobject without any connections. 

Of course, refresh is working on this table (second mouse button on table --> refresh) but i am trying to refresh it from code using:

For Each lo In wks.ListObjects
lo.QueryTable.Refresh BackgroundQuery:=False
Next lo

I do not have QueryTable in listobject property. Only looping through conenctions is solving the issue but connections do not have backgroundquery propery = false to set and it is casusing problems. 

How to create querytable in listobject after loading to workbook from power query and use backgroundquery property? 

Please help,
Jacek