Forum Discussion

Anonymous

Not applicable

7 years ago

Query Return Different Result in Desktop than when Published to Workspace

I have a query to calculate sales score with the sales%(image 1), it is calculating correctly in desktop (image 2), but when I published the report to the workspace and check right away, the sales sc...

Need Help

v-yulgu-msft

Microsoft Employee

7 years ago

Hi Anonymous,

I was not able to reproduce this problem on my side.

Please remove the report on Power BI service, and re-upload it directly from Service via clicking on "Get data" to see if problem persists. If possible, please share the sample .pbix file for check. Please mask the senssitive data before sharing.

Regards,

Yuliana Gu

Anonymous

Not applicable

7 years ago

Thank you for the response! But getting data directly from the service didn't solve the issue. So I want to rank the strategic group by category and marketplace. In the desktop version, when either of those filters is selected, the rank appears to be fine and the calculation for sales score is correct, but when published to the service, the calculation and rank get messed yo with these filter selected. When I published the table without the rank column, the sales score is calculating correctly regardless of filter selected. So I think must be something to do with the rank formula.

( In Service with filters selected)

(In Service with no filter selected)