cancel
Showing results for 
Search instead for 
Did you mean: 

Data Discrepancy in Web Service VS Desktop

I have a report that is returning different data form the dashboard to the web service. the data is from a measure and in the WS it returns 0 while in the report it returns the correct data.

Dashboard

jamboort_0-1601815981053.png


Web Service

jamboort_1-1601816058408.png

I have tried republishing but no difference. It seems to be the result coming back from the Measure that is not applying the filters or that the calculation is not functioning.

The measure is:

Current NO2 =
VAR V1 = LOOKUPVALUE (
Sensors[LastReadingValue],
Sensors[SensorTypeId], 2,0)
var r = " mg/L"
return CONCATENATE(V1,r)

Any idea on how I can solve this??
Thanks Ian


 

Status: New
Comments
v-yuta-msft
Community Support

@jamboort ,

 

I have made a test but couldn't reproduce this issue on my side. Please make sure power bi desktop has been updated to the latest version and clear the browser cache and then check if this issue persists.

 

Regards,

Jimmy Tao