Excel.CurrentWorkbook is a Power Query M function that retrieves the contents of the current Excel workbook, including tables, named ranges, and dynamic arrays. The function returns a table containing the workbook content.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Excel.CurrentWorkbook() as table
Returns the contents of the current Excel workbook. It returns tables, named ranges, and dynamic arrays. Unlike
Excel.Workbook, it does not return sheets.
Other functions related to Excel.CurrentWorkbook are: