Forum Discussion
Solved
Power Query not loading all data
Hi everyone, i have a query that loads the table "Database" and does other operations on it, then i load the query onto a oivot table. the problem is that when i add new items to the dynamic table "...
never mind i found what the problem was, the query was running from the old file version, thank you so much
No it didnt i tried to refresh all before and tried again now, still the new data added after creating the query were not added.
PhilipTreacy
Super User
Super UserCan 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.
Regards
Phil