Forum Discussion
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 "database" it doesnt show up in the pivot table, right now i have over 800 rows in the table while the query only shows 315 rows
never mind i found what the problem was, the query was running from the old file version, thank you so much
4 Replies
- PhilipTreacy
Super User
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
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.
Regards
Phil
never mind i found what the problem was, the query was running from the old file version, thank you so much
