Forum Discussion
Data is different in PowerBI and Power Query
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?
No and yes its very strange. For now I have again started from the scratch and I loaded the file locally this time, so now it's working fine. So I can atleast go forward. But later I will again import it from sharepoint like before and not sure if will face the same problem.