Desktop does not load all rows

[EduardoRossi]

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 is finished:

As you can see on the right side of the screenshot, I tried to filter the same column in the same table with the same value: no data was found.

Hope you understand my issue and everything is properly explained.

Please, can anybody help me? Every row is important in our dataset. Therefore, having missing data affects deeply in our daily work.

Thanks in advance,

Kind regards.

Eduardo

[Anonymous]

Hi @EduardoRossi ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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]

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]

@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]

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

[GiuseppeMR]

Hi,

Have you tried updating the table? (Right click on the table -> update)

From the second screenshot it appears there are pending changes in Power Query. Are these changes related to the table COEX?

[EduardoRossi]

Hi @GiuseppeMR,

That is because I had Power Query opened at the moment I made the screenshot.

Regards.

[GiuseppeMR]

Check the following:

-the Power BI table is updated

-there are no filters applied tò the Power bi table (second screenshot)

-there are no errors shown after updating the Power BI table.