Forum Discussion
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 s...
_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.
I got it. Thank you.