Forum Discussion
Data is different in PowerBI and Power Query
It's possible the reason you're not seeing everything is cause in powerquery it only shows the first 1000 rows and in the table view in power bi it shows a different number of rows
A way you can check this is in the power bi table view scroll to the last row and see which number tow it is and compare that number with the same row number in power query
I hope this helps somewhat
That is why I sorted in desc order, so even if I am not seeing all the rows, I should be able to compare atleast the top rows. Or do you mean power query sorts only the top 1000 rows and ignoring the other ones?
sort in power bi in desc order and see the top rows number and also scroll down till the bottom to see how many rows are being displayed like by me I saw there were 465 I think and then sort power query in asc order and scroll down to 465 or whatever number you saw in power bi and see if those numbers match
let me know what you see
I have some 8000 rows, and both Power Query and PowerBI showing all the rows if I scroll down.
Strange. Can it be that you're filtering any other columns or something like that?