Forum Discussion

Toots912's avatar
Toots912
Copper Contributor
Feb 16, 2022

GetData: Consolidate Excel Sheets using Power Query - Getting Error

Hi, 

I was combining worksheets in one excel file using GetData>From other Sources>Blank Query. I entered into the formula bar "=Excel.CurrentWorkbook()" to pull all the worksheets in the workbook so they can be combined as one data source for creating pivot tables.  Instead of showing "table" in the content column, it showed "error". I'm not sure what's causing it as my two worksheets have the same headings and number of columns. I don't know how to fix this. Am I missing a step or doing something wrong?

 

BI & Data Analysis

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 16, 2022

    Toots912 

    _FilterDatabase is the internal name which Excel gives to filtered range. Power Query doesn't work with such names. You need to name explicitly your ranges. As variant you may name entire columns, e.g. range1 as Sheet1!$A:$F and filter null when combine.

Resources