- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Subject | Author | Posted | |
---|---|---|---|
08-07-2024 08:54 AM | |||
05-06-2024 02:35 AM | |||
06-16-2024 03:22 AM | |||
09-14-2024 07:09 AM | |||
09-16-2024 12:12 AM |