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?