Direct Query Chart Error when making dimension selection

[israq]

Hi All,

I'm facing chart error when making dimension selection when using direct query.

No issue if the dimension is Integer but error with varchar data type.

Direct Query from MSSQL 2017

DIRECT QUERY
DIMENSION
CREATEDATE AS STORE_DATE,
 COMPANY AS COMPANY,
DIVISION AS DIVISION,
INVOICENUMBER AS STORE_BILLNO
 MEASURE
NETSALES AS STORE_NETSALES
FROM TABLE