cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thomaskelly Regular Visitor
Regular Visitor

Couldn't load the data for this visual

Hello all,

 

I have a strange one here.

 

I have a clustered column that breaks down company divisional sales by year, when I select one division on the clustered column chart all of my other charts normally filter through to highlight the related data. This was all working well until this morning.

 

On My desktop version when I click on the column that contains Blanks or No division set, it returns the following error message for all of the associated other graphs.

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

 

Strangely my online version which is the same in every way and was uploaded last week from the same file will filter through  with no issues, this updates the data automtically twice a day.

 

Has anybody else encoureted this ?

 

Feedback Type:
Frown (Error)

Timestamp:
2017-04-18T08:42:03.9648681Z

Local Time:
2017-04-18T09:42:03.9648681+01:00

Product Version:
2.44.4675.521 (PBIDesktop) (x64)

Release:
March, 2017

IE Version:
11.0.9600.18537

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.5.1 or later [Release Number = 378758]

Workbook Package Info:
1* - en-GB, fastCombine: Disabled, runBackgroundAnalysis: False.

Peak Working Set:
580 MB

Private Memory:
438 MB

Peak Virtual Memory:
3.88 GB

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



Telemetry Enabled:
True

Model Default Mode:
Import

Enabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_allowBiDiCrossFilterInDirectQuery

Disabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_EnableReportTheme
PBI_esriEnabled
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled

Disabled DirectQuery Options:
DirectQuery_Unrestricted

Cloud:
GlobalCloud

Activity ID:


Time:


Version:
2.44.4675.521 (PBIDesktop)

Error Code:
QueryUserError

OData Error Message:
Failed to execute the query.

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


1 REPLY 1
Community Support Team
Community Support Team

Re: Couldn't load the data for this visual

Hi @thomaskelly,

 

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

Above message told about the issue is related to "CONTAINSROW" function(error parameters type), can you provide the detail content of this visual and the formulas?

 

Can you share the sample file or pbix file to test? It' is hard to reproduce the issue without sample file.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |