Forum Discussion
Wrong data after the rows grouping
Hi,
I have a table with visits columns for each date row (total column and other columns by attribut), project column and analytics system column.
I need to group data to have SUM of total visits by project, year and analytics system.
I inserted year and then grouped rows by these 3 parameters.
After that I can see that the data in my database and the data in Power BI are different.
The data in the Power BI is 0.52% less then in my database.
What is wrong?
Thanks in advance!
7 Replies
in orer to identify the problem can you demonstrate what you have done in power bi?
are you using more than one table? if so please post a screenshot of your relationships
Hi, vanessafvg
This is what I've done:
http://prntscr.com/g0e4dr
The table is one. There are no any relationships.
In the added columns I've just summarized a few columns to have 1 column.
Hi ri2sina,
Would you please illustrate your problem with sample data? Please show us the steps to reproduce your scenario so that I can test for you.
Is there any difference between the data loaded into Power BI and stored in database before adding to visual?
If possible, please share the screenshots of current result and your expected result.
Regards,
Yuliana GuHi ri2sina,
Could you provide some sample data so that we can reproduce your scenario? And what did you mean "The data in the Power BI is 0.52% less then in my database"? What is the 0.52%? Were there any data rows missing in data model before grouping data?
Regards,
Yuliana Gu
