Table visual skipping some rows

[Rosh89]

Hi, 

I have connected powerbi desktop to an e-commerce database using odbc connection. I created a table visual and use this to export some orders. Everything works fine except that it skips 3 rows in the table visual. These 3 rows are however visible in the query editor.  I tried the options: Don't summarize and show items with no data. It still doesn't work. Does anyone have any idea why it may happen? 

[Rosh89]

@amitchandak Hi Amit, Thanks for the information. Is there any way to surpass this in powerbi itself? Does it also work the same way when creating other visuals? For ex. Card, bar graph etc.

[amitchandak · Accepted solution]

@Rosh89 , power bi always group the data, so if the two rows have the same values they will be shown as one even with do not summarize