Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Query (98, 131) Function 'CONTAINSROW’ Error

End users are receiving this error on 2 dashboard pages but I am not.

 

Query (98, 131) Function 'CONTAINSROW does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

Please try again later or contact support. If you contact support, please provide these details.

Hide details

Activity ID 36bf37a9-0b30-401a-b38c-0f0d2716fd69

Request ID bc2f055d-3ec8-48b8-a448-7d3708c6dd78

Correlation ID 236f325c-a5bb-883f-5065-e1e101aa03b7

Time Tue May 27 2025 14:47:29 GMT-0500 (Central Daylight Time)

Service version 13.0.25874.53

Client version 2505.1.24208-train

Cluster URI https://wabi-us-gov-virginia-redirect.analysis.usgovcloudapi.net/

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Due to current workload demands, I haven’t had the opportunity to fully investigate the dashboard error. In the meantime, I’ve uploaded a previous version of the dashboard for the customer to use until I can complete a more thorough review.

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Update: I’ve confirmed that this end user holds a Pro license. She closed and reopened the Power BI Server link twice today, and on the second attempt, the pages loaded correctly. It appears this isn’t a DAX code issue but rather a system-generated fallback error. 

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi Anonymous ,

      Thank you for sharing your experience!

      We really appreciate your efforts and for letting us know the update on the issue.Please continue using fabric community forum for your further assistance. 

      I'd like to confirm if you've successfully resolved this issue or if you need further help. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution. 
      If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you. 

       Best Regards, 
      Menaka.
      Community Support Team

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        I haven’t been able to pinpoint the error’s source since it never appears on my end, so I’m unaware when it affects users. Interrupting customers in the middle of their work just to check if the issue persists isn’t good business practice.

  • SreeniBattula's avatar
    SreeniBattula
    Helper II
    1 year ago

    Is there a calcualted column or measure created using CONTAINSROW DAX Function? check it are you comapring the valeus with same data type or not? you need to ensure that the data types of the values being compared are compatible.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      I understand, but I’m not seeing the error on my end. My users are encountering issues I can’t reproduce, so I’m unable to diagnose or confirm a fix. Without experiencing the error myself, it’s impossible to know if it’s been resolved.

      • SaiTejaTalasila's avatar
        SaiTejaTalasila
        Super User
        1 year ago

        Hi Anonymous ,

         

        Publish your report on a different workspace and check whether the same issue occurs or not. Incase if you are not seeing issues in the duplicate report, you can download the report and repubish it on to your production workspace.

         

        Thanks,

        Sai Teja