Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to Solution.
I found this thread to try out :
I found this thread to try out :
Yes, the problem disappears when I remove the incremental refresh 🤔
@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...
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |