Forum Discussion
Desktop does not load all rows
EduardoRossi , if you have filtered in Power query, then it added as step and only filter data is avaiable.
Make sure no filter step is added. if added by mistake remove it.
Hello amitchandak ,
Filter is removed before loading data, if not the amount of rows would be 13.
On the other side, I am not making any changes. I am just looking for a certain value in table 'COEX'. I can not find said value in Desktop, but once I click in 'Transform Data' and filter to find same value in Query, the value appears.
Thank you.
EduardoRossi , Please share you power query code. Also, make sure there is not Error folder in the Power query. It will add, if there data error, which has been ignored.
It is a pretty extense code. But it shouldn't matter, correct? Power Bi Desktop should show what Query shows at the last step.