Forum Discussion

OjasBI's avatar
OjasBI
Frequent Visitor
9 years ago
Solved

Column limit exceeded

 

The total number of columns in the model is 24858 which exceeds the limit of 16000.

How to increase the limit?

 

Need Help
  • OjasBI's avatar
    OjasBI
    9 years ago

    Okay.

     

    We have removed unnecessary columns and managed to go below the limit as of now.
    Incase I happen to face such a situation, I'll divide the rows.

    Thanks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You have a source system with 24,858 columns, is that correct?

     

    You might think about pulling in half of the columns into one table and half into another table with a key between them?

    • OjasBI's avatar
      OjasBI
      Frequent Visitor
      9 years ago

      Okay.

       

      We have removed unnecessary columns and managed to go below the limit as of now.
      Incase I happen to face such a situation, I'll divide the rows.

      Thanks