Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Issue in web service

Hi   Need an immediate help. I have a report which works absolutely fine in desktop version. But when i publish to web, only in 4 visuals (from two different worksheets) automatically some filters ...
  • Anonymous's avatar
    Anonymous
    6 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