I am trying to test out direct discovery for a few scenarios we have and am running into an error. Can you help me out with the syntax
I am trying to load one table using direct discovery the encounter the below error
Error -- expected <ColumnClauses>, found "
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company]"
DIRECT QUERY
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company]
The load script i am using
//ODBC CONNECT TO DSN_MM;
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Metric_Master;Data Source=XXXXXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XXXXXX;Use Encryption for Data=False;Tag with column collation when possible=False];
DIRECT QUERY
DIMENSION
[Company ID]
,[CompanyName]
MEASURE
[Sales]
FROM [dbo].[Company];