Power BI - Unable to display data in table

[Nuffy79]

I'm trying to visualise data from a column that has a data type of NCLOB but receive an error as per picture. I've encountered this in other reporting apps and have used a cast string to convert it to a varchar datatype. I"m new to Power BI and unsure if there is a similar way to achieve this. The source DB isn't able to be altered to a different datatype. Power BI treats it as a Datatype of "text" when loading the table. Thanks in advance.

[v-shex-msft]

HI @Nuffy79,

It seems like power bi not support NCLOB type, I'd like to suggest you convert these to string at the additional query.

TO_CHAR (character)

BTW, power bi not support the analysis some of particular datasource type(such as geometry, blob, geography), you should convert them to normal type. Why did you want to use nclob type in power bi ?

Regards,

XIaoxin Sheng