Forum Discussion
Solved
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 found this thread to try out :
amitchandak
Super User
Super Userplesaulnier ,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...