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

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