Direct Query Chart Error when making dimension selection
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