Forum Discussion
Filter Issue in web service
- Anonymous6 years ago
Hi All
First of all thanks all of you for your immediate response and help me to deep dive into this problem and also suggested me to open support ticket on this issue. When i was having remote session with Microsoft team then suddenly i was able to reproduce the issue in my desktop version and found the culprit.
Resolution :
In my data source there are multiple tables where one STATUS column was having value TRUE/FALSE, as i didn't convert those to True/False data type and designed all my measures handling them as STRING. It works well in dekstop version but when this was getting published to web service, then service internally is converting them or i would say treating them as TRUE/FALSE ( Binary data type ) and all my measures was failing whereever those have been used in visuals.
I have now converted those datatype as True/False and tweaked all those measures. Published again and boooooom, it's okay now.
Request to admin to close this thread.
thanks
Musfeq Saleheen
Hi All
First of all thanks all of you for your immediate response and help me to deep dive into this problem and also suggested me to open support ticket on this issue. When i was having remote session with Microsoft team then suddenly i was able to reproduce the issue in my desktop version and found the culprit.
Resolution :
In my data source there are multiple tables where one STATUS column was having value TRUE/FALSE, as i didn't convert those to True/False data type and designed all my measures handling them as STRING. It works well in dekstop version but when this was getting published to web service, then service internally is converting them or i would say treating them as TRUE/FALSE ( Binary data type ) and all my measures was failing whereever those have been used in visuals.
I have now converted those datatype as True/False and tweaked all those measures. Published again and boooooom, it's okay now.
Request to admin to close this thread.
thanks
Musfeq Saleheen