Forum Discussion

rolf1994's avatar
rolf1994
Icon for Helper II rankHelper II
9 years ago

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

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:  ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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's avatar
rolf1994
Icon for Helper II rankHelper II
9 years ago

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.