Knowledge Drop

What is the column limit?

  • 6 April 2021
  • 0 replies
  • 919 views

Userlevel 5

Last Tested: Aug 13, 2018

 

For unpivoted queries, there is no limit. You could potentially at any time build a result set that is wide enough to crash a browser if unpivoted. (The benchmark there is around 30,000 data cells.)

We do apply a default of 50 columns (docs) and a hard limit of 200 columns when pivoting in order to try to control the amount of data. (Note that "column limit" here is a bit of a misnomer—the limit is actually 200 pivoted values. So if you have 2 measures selected, you can have up to 2 measures x 200 pivoted values = 400 columns. But this many columns could crash your browser.)

If you need more than that, download the results unpivoted and then pivot in an external tool like Excel instead.

 

This content is subject to limited support.                

 


0 replies

Be the first to reply!

Reply