Forum Discussion
Query Return Different Result in Desktop than when Published to Workspace
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
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)
Rank Query
(Desktop no filter selected)(Desktop with filter selected)
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)
Rank Query
(Desktop no filter selected)(Desktop with filter selected)