none
What is the maximum length of the sql statement in PowerPivot?

    General discussion

  • Dear

    What is the maximum length of the sql statement in PowerPivot? One of my queries consist of 44910 characters (305 lines) but it looks like the SQL Statement textbox in Table import Wizard only allows about 32000 characters. The best solution would be to create a view on the database but for reason we do not have no create permissions we cannot go for this alternative.

    Can the maximum length of the query be extended in PowerPivot?   

    Kind regards

    Eddy


    Eddy Nijs

    Thursday, April 18, 2013 1:37 PM

All replies

  • Hi Nijs,

             I have tested with sample text, it supports almost >32000 character length.


    ChinniKrishna T Database developer

    Tuesday, April 23, 2013 7:43 AM