I am testing out Direct discovery for one of the scenarios we have and running into the below error. Can you help with the syntax?
Error -- expected <ColumnClauses>, found "
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company]"
DIRECT QUERY
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company]
Below is my load script
//ODBC CONNECT TO DSN_MM;
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Metric_Master;Data Source=gasqlst07d;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GA-KITAMBIS2;Use Encryption for Data=False;Tag with column collation when possible=False];
DIRECT QUERY
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company];
