Tabular Error in project

KamiFen 121 Reputation points
2020-09-03T06:58:27.243+00:00

Hi,

I am currently working on a SSAS tabular model cube. I am getting the below error. Plz someone could help on this ?

The size of a data value in table '<#####>' column '<******>' was too large to fit in that column. The current operation was cancelled because another operation in the transaction failed.

thanks a lot

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,007 questions
No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points
    2020-09-03T07:22:13.037+00:00

    Hi,
    In SSAS Tabular Model, we the cannot import from a varchar(max) column that contains a string length of more than 131,072 characters.
    This is the limitation for DAX data type, you have to truncate into shorter string to separate into two columns.
    There's no effective workaround.
    Please see reference here : Data types used in tabular models

    Regards,
    Lukas


0 additional answers

Sort by: Most helpful