Refresh only internal connections in excel power query / Data model

Question

I have a rather large datamodel in excel. it consists of an imported data mart featuring one fact table and around 20 dimension tables.

I also have 3 tables directly in the excel sheet, where users can enter data, that then gets merged into the existing datamodel using power query.

I would like to be able to update the datamodel thereby updating the content of my pivot tables and my calculations, without refreshing the actual data coming from my external server.

Is this possible without having to disable external data connections i the sheet (I'd like to periodically update the data)

For clarification, i am building a KPI that will be measured monthly on data present on the 1st of every month, but will have to be analyzed, commented, and have outliers handled throughout the month.

Answer 1

You've not mentioned VBA in your question, but going by the fact you've tagged your question as VBA, I'm guessing that's what you're using?

VBA code to refresh a single query is:

Sheets("sheetName").ListObjects("queryName").Refresh

If you're trying to do it manually, then it's just a question of selecting a cell within the table the query is pulling to, and then Query > Refresh.