Forum Discussion

EduardoRossi's avatar
EduardoRossi
Frequent Visitor
1 year ago

Desktop does not load all rows

  If you zoom in on the image below, I have filtered table 'COEX' by column 'CodUnidad' = 'EPNZA424'   Data has been found. Now let's filter the same data in Power Bi Desktop once the load i...
General Comment
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
1 year ago

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.

  • EduardoRossi's avatar
    EduardoRossi
    Frequent Visitor
    1 year ago

    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.

    • amitchandak's avatar
      amitchandak
      Super User
      1 year ago

      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.

      • EduardoRossi's avatar
        EduardoRossi
        Frequent Visitor
        1 year ago

        It is a pretty extense code. But it shouldn't matter, correct? Power Bi Desktop should show what Query shows at the last step.