POWER BI is not displaying the same SQL view

Hi erisant 

Where did you find that the 2nd row is missing? In Power Query Editor or in Power BI Desktop?

If it's missing in Power BI Desktop after you hit Apply in Power Query Editor, please let me know whether it's missing in Data view, or in a table visual on report page? If it's missing in Date view, please check if there is any filter applying on any columns. Click on one column header and select "Clear all filters".

If it's missing in a table visual, check if you have added "zassocrow" column to the visual. A table visual will not show totally duplicated rows, which is by design. In your view data, the 1st row and 2nd row have the same value in all columns except in "zassocrow" column. So if "zassocrow" column is not in it, it will display only two rows. However, if "zassocrow" column is added, all three rows will display. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.