Forum Discussion
Problem with count ID / number of rows
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 ?
I found this thread to try out :
4 Replies
I found this thread to try out :
- amitchandak
Super User
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
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...
Yes, the problem disappears when I remove the incremental refresh 🤔
