The data types uniqueidentifier and nvarchar are incompatible in the add operator.

[rolf1994]

Hello,

I am getting an unexpected error when trying to load a report. I do not know what is causing this error so i thought someone here might know the answer. the error is as following:

I am using direct query.

Thanks in advance!

[v-qiuyu-msft]

Hi @rolf1994,

Assume you connect to SQL Server database in DirectQuery, have you specified any T-SQL query when you get data? Does this specific visual can't display data, other visuals are fine? Check if any calculated column or measure added in this visual, if it is, please check its data type.

Which desktop version did you run? Please share detail information for us to analyze the issue.

Best Regards,
Qiuyun Yu

[rolf1994]

@v-qiuyu-msft

Assume you connect to SQL Server database in DirectQuery - Yes

have you specified any T-SQL query when you get data? - Yes, and it looks like if I do not use T-SQL query I do not get an error. However, I do not want to use all the data in the table.

Does this specific visual can't display data, other visuals are fine? - No, other visuals also show an error

Check if any calculated column or measure added in this visual, if it is, please check its data type. - I created a column using the concatenate function. 

I worked in the latest desktop version.

[Greg_Deckler]

Sounds like you are trying to add a uniqueidentifier (numeric) with a text value (nvarchar) which isn't going to work well. You would need to cast the nvarchar to an integer or float.