killermonkey
New member
- Joined
- Mar 29, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
So I'll start out by saying that this blog has been a life saver. I just found the amazing gift of Power Query and had it not been for this blog I would have been stumbling in the dark to try and figure it out. So thank you!
That being said I'll quickly explain my situation and predicament. I'm working on an office computer which unfortunately is a 32-bit system with a whopping 4 gigs of RAM. I quickly realized that once I hit a certain data threshold in Power Query I get the dreaded out of memory issues. To try and counter this I decided to create some of my more complex queries in a separate workbook and once I have them all formatted the way I want them I would pull them into my main workbook thus, in theory minimizing the load on my poor computer. However, the problem that has ensued is the primary workbook, that I've pulled the backend query into won't refresh when the data changes. In an attempt to make it clearer:
I have two workbooks. The primary or frontend is called "Dashboard." The backend that I want to pull into the Dashboard is called "POSSX." POSSX consists of 11 queries that I've combined/transformed into a singular query. I then opened my Dashboard workbook, Get External Data from Excel, pull in the POSSX query and I now have 1 query in my Dashboard as opposed to the 11 in POSSX, thus preventing the memory issues. The problem now is that when the data changes that feeds the POSSX workbook/query it will update in that workbook if I open it and refresh all but without doing that, it won't update in the Dashboard workbook.
My question then is there a way to update the POSSX query in the Dashboard workbook without having to open the POSSX workbook first? Basically I want to link a query from one workbook into another and have it refresh in my frontend without having to manually open and refresh the backend first. If all that was confusing please let me know.
Thank you for any help in advance.
Tyler
That being said I'll quickly explain my situation and predicament. I'm working on an office computer which unfortunately is a 32-bit system with a whopping 4 gigs of RAM. I quickly realized that once I hit a certain data threshold in Power Query I get the dreaded out of memory issues. To try and counter this I decided to create some of my more complex queries in a separate workbook and once I have them all formatted the way I want them I would pull them into my main workbook thus, in theory minimizing the load on my poor computer. However, the problem that has ensued is the primary workbook, that I've pulled the backend query into won't refresh when the data changes. In an attempt to make it clearer:
I have two workbooks. The primary or frontend is called "Dashboard." The backend that I want to pull into the Dashboard is called "POSSX." POSSX consists of 11 queries that I've combined/transformed into a singular query. I then opened my Dashboard workbook, Get External Data from Excel, pull in the POSSX query and I now have 1 query in my Dashboard as opposed to the 11 in POSSX, thus preventing the memory issues. The problem now is that when the data changes that feeds the POSSX workbook/query it will update in that workbook if I open it and refresh all but without doing that, it won't update in the Dashboard workbook.
My question then is there a way to update the POSSX query in the Dashboard workbook without having to open the POSSX workbook first? Basically I want to link a query from one workbook into another and have it refresh in my frontend without having to manually open and refresh the backend first. If all that was confusing please let me know.
Thank you for any help in advance.
Tyler
