Problem with count ID / number of rows

[plesaulnier]

Hi, 

I have a dataset in power bi that shows +2 rows than the count i have in sql server with the sql view used for the same dataset. 

I narrowed the date / time where I find these 2 extra rows : 

I have here 2 IDs only but the last column count 2 per rows for some reason. 

Any idea why ? 

[plesaulnier · Accepted solution]

I found this thread to try out : 

https://community.powerbi.com/t5/Desktop/Problem-with-incremental-refresh-on-power-bi-premium/m-p/73...

[plesaulnier]

Yes, the problem disappears when I remove the incremental refresh 🤔

[amitchandak]

@plesaulnier ,Based on what I got 

is it count or the distinct count? If this a count , it means in power bi has two rows

[plesaulnier]

@amitchandak Hi, that's the issue - it is count but Power BI has only 2 rows 

On the left ID column in my screen shot, I display the 2 existing values

On the right ID column in my screen short, I display the count (not distinct count on purpose)

I just configured the incremental refresh this morning - I wonder if that is not causing any issue...