Excel Power Query Refresh Does Not Update

[legalhustler]

Hello,

I am using Excel 365 and connected power query to a SQL server database. I do some simple transformations then load the data to the workbook, I also resize the table range by adding some additional columns to the end where I do some complex Excel formulas (which I do not know how to in Power Query). When I refresh the workbook by going to the Data tab> Refresh All the table does not get updated. However, when I open the query and filter the data I see the new record do exist but it does not get loaded to the workbook. The property settings of the query has a check next to "Refresh this connection on Refresh All" and even "Refresh data when opening file". The query does say "10,046 rows loaded"

Additionally, when I click the loaded table on my workbook I only see Table Design tab show, whereas I have separate query when I click that loaded table I see the Table Design and Query tab show. Why do I not see the Query tab show on my first table? Is it because I resized the table range and added my own formulas? Is this also causing the table not to refresh with latest data?

 

[johnny51981]

Have you tried to change the Load To... to "Only Create Connection" and then change it back to "Table"? I just experienced something this morning where the table loaded, but found its way disconnected from the query it loaded from.

Right click on the query that you are expecting to refresh
Select "Load to"
Select "Only Create Connection"
Click OK

Delete the previously loaded data, as this has been disconnected from any query.

Right click on the same query
Select "Load to"
Select "Table"
Point to the cell on the Existing Sheet you would like to load to
Click OK
Refreshed table will load, then re-add in your formulas

 

[legalhustler]

Have you tried to change the Load To... to "Only Create Connection" and then change it back to "Table"? I just experienced something this morning where the table loaded, but found its way disconnected from the query it loaded from.

Right click on the query that you are expecting to refresh
Select "Load to"
Select "Only Create Connection"
Click OK

Delete the previously loaded data, as this has been disconnected from any query.

Right click on the same query
Select "Load to"
Select "Table"
Point to the cell on the Existing Sheet you would like to load to
Click OK
Refreshed table will load, then re-add in your formulas

Yeah that’s what I usually do when this happens but I don’t understand why the query breaks like this sporadically. The workbook is saved on SharePoint and other users say they don’t tamper with it