Excel.CurrentWorkbook

Updated on

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

Syntax

Excel.CurrentWorkbook() as table

Description

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:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/excel-currentworkbook