legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,195
- Office Version
- 365
- Platform
- Windows
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?
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?
