Forum Discussion
Unexplainable behaviour between Desktop and Service - values change
Idrissshatila it's possible that I found it... It seems that Desktop and Service treats blank differently, e.g.,
in Dekstop:
(blank()<>"xyz")=false
but in Service
(blank()<>"xyz")=true
I had a measure that relied on that implicit ((blank()<>"xyz")=false) behaviour and it seems that it was the one that was messing things up.
Hello austris ,
there must be applied filters on service, try reseting filters using the green icon in the screenshot.
subscribe to My youtube channel https://www.youtube.com/@PowerBISolution
Thanks Idrissshatila - tried that - makse no difference...
austris this is weird, there must be a filter that is affecting your data.
Idrissshatila it should be something like that right? But I'm not sure it is because this is exactly step by step what I'm doing:
- refresh semantic model in service (actually the refreshing at this stage doesn't matter I don't think as the result is the same regardless)
- open the report in service -> my visual says=138 (the wrong number)
- I download the file from Service and open it in Desktop doing absolutely nothing else and the exact same visual says =5 (the correct number)
Actually the same behaviour affects multiple measures - the only constant that I noticed is that data in Desktop are correct, in Service incorrect.
I even tried re-publishing it as a new report/semantic model hoping that it makes a difference but did not - still the same issue...
How's that possible?