Forum Discussion

ri2sina's avatar
ri2sina
Helper I
9 years ago

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 visit...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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's avatar
ri2sina
Helper I
9 years ago

Hi, v-yulgu-msft

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

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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's avatar
      ri2sina
      Helper I
      9 years ago

      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's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        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