Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

How do I include the Excel sheet name for a given table when importing from a folder?

I am importing the contents of a folder of Excel files using Excel.Workbook([Content[). When I expand this column, I get an Item column and a Name column, but they both list the name of the tables in question. I want to import using tables but associate the sheets with the tables as I import. Is this possible?

Community Support
Community Support

Hi @dehmos27 ,


>>I am importing the contents of a folder of Excel files using Excel.Workbook([Content[).


Does it mean geting data from the Folder connector like below? If so, when you click the "Load" option, it already has the Excel sheet name.

6.png7.pngBest Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Thank you for your response. The sheet name does show by default, but this does not work if attempting to combine multiple Excel workbooks with varying table structures into a single file. Where the issue crops up is after clicking "Edit" before performing the "Combine" step, you add a custom column that uses the code provided: =Excel.Workbook([Content]). When a user expands the new custom column, he or she can filter to either import tables or sheets, but the tables do not give the Worksheet name (sadly).

Hi @dehmos27 ,


Could you please show your issue page screenshot for further analysis?


Best Regards,


Here is a sample:


When I reference the workbook using the previously described Custom column, I get the following:


Screen Shot 2019-07-24 at 9.19.50 PM.png


I want to know if it is possible to actually expose the name of the sheet on which the table belongs to preserve the metadata stored in the sheet title. So, for Table 1, 19AprUsedCAD might be the name of the sheet, and so on.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors