Power Query not loading all data

[mohamed_Ahmed14]

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

[mohamed_Ahmed14 · Accepted solution]

never mind i found what the problem was, the query was running from the old file version, thank you so much 

[mohamed_Ahmed14]

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]

Hi @mohamed_Ahmed14 

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

[PhilipTreacy]

Hi @mohamed_Ahmed14 

Try doing a Refresh All to refresh the Pivot table too.

regards

Phil