Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

PowerBi Report Builder wrong data

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,

Sorbello_0-1683015484737.png

 

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.

Sorbello_1-1683015564403.png

 

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?

 

Status: Investigating

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

Comments
v-yanjiang-msft
Community Support
Status changed to: Investigating

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