Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Query shows non-zero values, Table View shows only zeros

This has happened to me a couple times now so it must be something that I'm doing in my transformations.   Import a "wide" excel file, reverse pivot the columns so that the months run down not acro...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous Those don't appear to be the same data rows. Remember that preview only shows the first 1000 rows. Two things to try. One, in Table view, try sorting descending for your Value column (right-click, sort descending) and see if values show up. Second thing, in Power Query, click the dropdown for the Value column to filter and click "load more values" and see if 0's show up.