PowerBi Report Builder wrong data

[Sorbello]

I connect power bi report builder to the power bi service, once i create the dataset and try to run the query, the results it gives me are replicated for each customer name,

but actually the real dataset would be like this, in column a left are summed up in the right column we find the unsummarized data.

The problem is that on power bi desktop the results are correct as you can see, while on report builder it replies the values ​​that are not really correct, how do i fix it?

[v-yanjiang-msft]

Hi @Sorbello ,

Please try to put the column "Customer Names" in Row group and select Sum to the column "Sales".

Refer to: Understanding groups in a paginated report - Microsoft Report Builder  | Microsoft Learn

Best regards,

Community Support Team_yanjiang