cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohamed_Ahmed14
New Member

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

1 ACCEPTED SOLUTION
mohamed_Ahmed14
New Member

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

View solution in original post

4 REPLIES 4
mohamed_Ahmed14
New Member

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

mohamed_Ahmed14
New Member

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.

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

 



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.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

Hi @mohamed_Ahmed14 

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

regards

Phil



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.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors