title: How to create partitions in SSAS tabular 1400 compatibility?
body: <p>We are implementing <code>SSAS 2017</code> tabular mode for our reporting needs. I am trying to create partitions in one of the tables. I built a SQL query for the partitions. While the SQL query works fine on the database, it throws an error when validating using the partition manager. I tried to use the query editor but couldn't get much. I tried to check the query using advanced editor in query editor which says there are no syntax errors.</p>
  
  <p>Following is the query I am passing:</p>
  
  <pre><code>SELECT
  [Account - Company Code],
  [Additional 1],
  [Additional 2],
  [Additional 3],
  [Additional 4],
  [Additional 5],
  [Additional 6]
  FROM dbo.[Table Name]
  WHERE [Date - Accounting] &gt;= '2012-01-01' AND [Date - Accounting] &lt;= '2012-01-31'
  </code></pre>
  
  <p>The error I get in Query Editor is </p>
  
  <blockquote>
    <p>Expression.SyntaxError: Invalid identifier.</p>
  </blockquote>
  
  <p>Please help me sort the issue.</p>
  
  <p>I read on MSDN that in a model of 1400 compatibility the partitions need to be created using Power Query M language but I am unable to retrieve any examples to do this.</p>