locked
Powerpivot issue : one or more formulas in this workbook are longer than the allowed limit of 8192 characters + Cannot load the data model RRS feed

  • Question

  • Hello,

    I use Powerpivot every day with a lot of SQL Server queries, some of them pretty long or complex and I have never the following issue : I had to write a 1,500-row SQL Server query that works fine on my editor and when I run it in Powerpivot, I am getting either of the following messages :

    - "one or more formulas in this workbook are longer than the allowed limit of 8192 characters" : I tried to save the file in regular format or binary format but still can't save it.

    - after closing the Powerpivot back-end menu (via "Manage"), when I want to access it again, I get a ""Powerpivot is unable to load the Data Model" error message.

    There are no formula on the front-end of Excel, all the data resides in the back-end, so what does it mean? Is it counting the total characters in the SQL Server query itself?

    I couldn't find any specific support on this, is it due to the size of the SQL Server query? To specific tables inside the query? To some formatting that need to be done in the SQL query?

    Thank you very much for your support on this.

    Thursday, April 12, 2018 2:10 PM

Answers

  • Hi Philarn,

    Thanks for your question.

    There is a limitation listed in article Excel specifications and limits , it talks about the length of formula contents: "8,192 characters".

    >>>There are no formula on the front-end of Excel, all the data resides in the back-end, so what does it mean? Is it counting the total characters in the SQL Server query itself?

    Yes, including the SQL query itself ,the SQL query can not be longer than 8192 characters either.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, April 13, 2018 2:03 AM