Importing Excel Files using PrintAreas and Tables RRS feed

  • Question

  • When using PowerQuery to import data from an Excel File usually each worksheet is displayed as one table
    further, also each Print Area is available as a separate source

    this only works as long as a worksheet only contains exactly one Print Area, as soon as a second Print Area is added to the same sheet both Print Areas disappear from the list of source within the Excel File

    Though, the idea of using Print Areas to define areas that can be imported using Power Query is a good idea
    where this approach hits its limits is when you try to import an Excel table using Power Query

    you cannot select the table itself as a source - WHY???
    using a Print Area for this purpose would work initially but would fail as soon as the table grows

    is it planned to add Tables that reside inside an Excel sheet as Source for Power Query?

    kind regards,

    - -

    Monday, September 9, 2013 9:14 PM


  • Hi Gerhard,

    Thanks for your feedback. We're exploring the feasibility of adding Sheet Tables to the list of items in the Navigator when using "From Excel Workbook".


    Saturday, September 21, 2013 12:04 AM

All replies