Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Fabric Community site will be in read-only mode on Monday, Feb 24 from 12:01 AM to 8 AM PST for scheduled upgrades.

Reply
han_rj
Advocate II
Advocate II

Excel.currentworkbook() not working shows no tables

Hi All,

 

I have a Excel workbook to load in Power Query using Excel.CurrentWorkbook() fuction but this does not return any result.Please may I have help correct me.

han_rj_0-1739790301367.png

 

 

 

 

1 ACCEPTED SOLUTION

Hi @han_rj,

Thank you for being a part of Microsoft Fabric Community Forum!

Excel.CurrentWorkbook() is designed for use inside an Excel workbook’s own Power Query environment. It returns tables and named ranges within the same Excel file.

In Power BI Desktop, there is no “current workbook” concept. The .PBIX is not the same as an Excel workbook. So, calling Excel.CurrentWorkbook() from within a .PBIX will simply return an empty result or error because Power BI has no reference to an Excel workbook in memory.

Instead of using Excel.CurrentWorkbook(), select Get data, Excel workbook and choose your .xlsx file.
This is the most straightforward way to load Excel data into Power BI.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

 

Regards,
Sahasra.

View solution in original post

3 REPLIES 3
Akash_Varuna
Responsive Resident
Responsive Resident

Hi @han_rj , Could you checj these please

  • No Tables: Ensure that your workbook has properly defined Excel tables or named ranges.

    • Select the data in your Excel sheet and press Ctrl + T to create a table.
    • Alternatively, define a named range by selecting your data and naming it in the name box.
  • File Format: Excel.CurrentWorkbook works only with Excel workbooks in .xlsx or .xlsm format. If your file is in .xls or another format, save it as .xlsx and try again.

  • Power Query Settings: Ensure you're working with the correct query editor and accessing the desired workbook.
    If this post helped please do give a kudos and accept this as a solution
    Thanks In Advance

 

 

Yes the above all is there.

 

Please correct my steps
1. Open new PBIX file in POwer BI desktop
2. Power Query > New Source > Blank Query>
= Excel.CurrentWorkbook()

 

han_rj_0-1739790330419.png

 

Hi @han_rj,

Thank you for being a part of Microsoft Fabric Community Forum!

Excel.CurrentWorkbook() is designed for use inside an Excel workbook’s own Power Query environment. It returns tables and named ranges within the same Excel file.

In Power BI Desktop, there is no “current workbook” concept. The .PBIX is not the same as an Excel workbook. So, calling Excel.CurrentWorkbook() from within a .PBIX will simply return an empty result or error because Power BI has no reference to an Excel workbook in memory.

Instead of using Excel.CurrentWorkbook(), select Get data, Excel workbook and choose your .xlsx file.
This is the most straightforward way to load Excel data into Power BI.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

 

Regards,
Sahasra.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors