title: Powerpivot sql query fails - Unable to convert a value to the data type requested for table column
body: <p>I'm trying to execute a sql query through powerpivot and I get the following error </p>
  
  <p>"Unable to convert a value to the data type requested for table (massive hex string) column (name)"</p>
  
  <pre><code>SELECT [name], [table].[group],[table2].[group2] ,SUM([number]) AS number
  FROM table LEFT JOIN [table2] ON table.[group ID]  = [table2].id 
  GROUP BY [name],[table].[group],[table2].[group2]
  </code></pre>
  
  <p>Powerpivot's validator is happy with the query and the same query runs fine through sql management studio, any ideas how I can fix this?</p>