Can you supply your file and query, hard to debug without them.
Have you gone through the query step by step to make sure it's not somehow excluding this 'new' data? I have a set same as yours where I load data from an API with PQ and load that data into a Pivot Table. Refresh All works ok for me in that situation.
Did I answer your question? Then please mark my post as the solution. If I helped you, click on the Thumbs Up to give Kudos.