Table with more than 1 048 576 rows in POWER QUERY (Excel 2013) RRS feed

  • Question

  • Hello,

    I'm trying to build a Data Model in Power Pivot : I appended a lot of large CSV files and the number of records would be 1312109 so Excel rejects my query. I read it was possible to go over the Excel limitation, but how to do that?

    Thanks for your help

    Sunday, July 27, 2014 3:41 PM


  • You can import text data directly into the Power Pivot window -- bypassing Excel's row limit.

    • Proposed as answer by Mark Weisman Monday, July 28, 2014 9:09 PM
    • Marked as answer by WLID1966 Tuesday, July 29, 2014 5:58 AM
    Monday, July 28, 2014 9:09 PM