Wrong data after the rows grouping

[ri2sina]

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!

[v-yulgu-msft]

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 Gu

[ri2sina]

Hi, @v-yulgu-msft

The difference is already in the Query Editor in the table with changes.

[v-yulgu-msft]

Hi @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

[ri2sina]

@v-yulgu-msft

Sorry, I haven't permission to provide data sample.
I didn't remove any columns.

I pulled out the data from my SQL database.
If I compare the aggregated data in my SQL database with the Grouped data in Power BI, I will have the difference between the data in each row.

I removed the added columns and checked the data after grouping; it is still wrong.

[v-yulgu-msft]

Hi @ri2sina,

It would be better that you could share the screenshot of result you got in Power BI and in SQL DB.

Also, to better describe your problem, you could create some simplified sample data so that we can better understand your problem with example.

Regards,
Yuliana Gu

[vanessafvg]

@ri2sina

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

[ri2sina]

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.