Query (98, 131) Function 'CONTAINSROW’ Error

[anghardin01]

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/

[anghardin01]

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]

Hi @anghardin01 ,

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

[anghardin01]

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.

[v-menakakota]

Hi @anghardin01 ,

Thank you for the update, and we completely understand your concern.

Since the issue did not reoccur after a refresh and everything is working fine now, it seems like it was a temporary glitch possibly related to data type handling or a brief service interruption.

At this point, since the problem isn’t present anymore, you may consider marking the thread as resolved. This helps other users who might face a similar situation and keeps the forum organized.

If the issue comes up again in the future, feel free to reopen the thread or start a new one we’re here to help!

Thank you again for your patience and for working through this with us.

 Best Regards, 
Menaka.
Community Support Team

[v-sshirivolu]

Hi @anghardin01  ,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[anghardin01 · Accepted solution]

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.

[v-sshirivolu]

Hi @anghardin01 ,

Thank you for the update, and completely understand — we appreciate you taking the time to respond despite your current workload.

Reverting to a previous version sounds like a practical interim solution. Once you're able to complete your review, feel free to share any additional findings or confirm whether the original suggestion resolves the issue.

Please don't hesitate to reach out if you need any further assistance in the meantime.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best regards,
Sreeteja
Community Support

[v-sshirivolu]

Hi @anghardin01   ,
Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sshirivolu]

Hi @anghardin01   ,
Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sshirivolu]

Hi @anghardin01   ,
Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[SreeniBattula]

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.

[anghardin01]

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]

Hi @anghardin01 ,

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