PowerQuery Tables not refreshing like they should

[rizzo93]

I'm having trouble getting my data to refresh in my powerquery tables.

I start with a data connection using a SharePoint list. Then I make a powerquery table from that to modify what I need.

Then I have another powerquery table that merges that table. It's this last table that doesn't always refresh with changes made from the source in SharePoint each time I refresh.

It takes two maybe three times of refreshing everything that the changes finally show up in my table.

The code I'm using to refresh is:

ActiveWorkbook.Connections("Query - q_Comments").Refresh

Any idea of why this occurs?

 

[rizzo93]

I wonder if it's perhaps that I'm referencing query tables instead of just duplicating them. I thought referencing connected the duplicate back to the original query table and would update automatically.

In any case, does anyone know the difference/impact to referencing a query table versus duplicating it?