Forum Discussion

Madhan_'s avatar
Madhan_
Frequent Visitor
3 years ago

Handle negative values in power query

I don't understand how this works. Below I have attached the images of the same dataset from the Power Query window and Data Window. In the data window, the Column unit price is showing a neg...
jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

I noticed that in the data window view your dataset is almost 542000 rows while in the Power Query view it is only showing the top 1000 rows. If you expand the Power Query view to include all rows does your missing negative value show up?

Madhan_'s avatar
Madhan_
Frequent Visitor
3 years ago

I clicked load more values in the right click menu on price unit column. But still it shows only 1000 values maximum and says limit of 1000 values reached. so how do i expand more than that?