Power Pivot not import all columns from Excel RRS feed

  • Question

  • I have an Excel spreadsheet with 300 columns and when I try to import them into Power Pivot, it loads only 80 columns?

    How can I solve de problem by importing data?

    Tuesday, September 12, 2017 1:50 AM


  • Hi WilliamArd,

    Thanks for your question.

    Which Excel version are you using?

    As I test in Excel 2016, I can import a table with 153 columns. See below image:

    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

    Tuesday, September 12, 2017 3:19 AM