Missing data after closing the Query Editor

[Anonymous]

Hello,

After I click close & apply, only a limited amount of data displays on the table at Home. For example, January 1st only contains 11 tools while the query editor correctly contains all 23.

I have tried to click refresh on the home screen and click refresh after right-clicking on the table to the right. I thought about reloading this table after removing any preview features, but there was nothing checked off to begin with. Any suggestions? 

[christianfcbmx]

HI @Anonymous ,

Did you try to hit the button "update all" before close and apply?

[Anonymous]

Thanks for your help @christianfcbmx where is the button? I feel like I have searched everywhere for it.

[christianfcbmx]

GO TO EDIT QUERY, and then do the sequence in the pic below (My PBI is in spanish so find the equivalence):

Tell me if it works.

[Anonymous]

@christianfcbmx It did not work. In my screen, it is called "refresh all"

[christianfcbmx · Accepted solution]

Maybe they dates are not in order.... in the column "Month-Year" (Home table) that you dont see them all, order it ascending...or filter by January  to see what we have.

[Anonymous]

Thank you!