Forum Discussion

PBE's avatar
PBE
Helper II
2 years ago
Solved

Excel Data Manipulation & Power BI

Hi I download an Excel workboot and it has a number of sheets in it all in the same format. In power query I know how to extract the data in rows 6 to 10 and combine the sheets. The person's...
  • PBE's avatar
    2 years ago

    Hi I've subsequebtly realised this isn't necessary as when loading workbook into power bi the 1st column contains the sheet name.