title: Varchar(MAX) field being truncated in SSAS cube
body: <p>In SQL Server 2016 I have a relational dimension table that has a field set to varchar(MAX). Some of the data in that field is over 2k characters. When this data is processed by SSAS the field is truncated. It seems to be truncating at 2,050. I have searched the XML for the whole cube to see if I can find 2050 (or 2,050) but it doesn't show up.</p>
  
  <p>In the Data Source View the field length is -1. My understanding is that this means unlimited. In the dimension definition the field is WChar and the DataSize is 50,000.</p>
  
  <p>I can't for the life of me find why this field is being truncated. Where else can I look?</p>
  
  <p><strong>UPDATE:</strong> The issue was with Excel. When we view this data using PowerBI the field is not truncated. So the data in SSAS is fine.</p>