Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
57 | |
54 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |