Power Query importing Files from a Folder Error

DMfba

New Member
Joined
Mar 21, 2019
Messages
8
Hi All,

I hope this is a simple fix that. I am importing multiple excel .xlsx files from a folder as i have done in many times in the past but came across an error i can not resolve. After selecting my folder that I want power query to import i go into the edit option to extract the excel data in the file. Typical i would remove all but the content column then add a custom column. The formula i am using is =Excel.Workbook([Content]). After creating the column it shows there is an errors in each row.

Expression.Error: We cannot apply field access to the type Function
Details:
Value=Function
Key=Content

Does anyone know how to fix this error? Or a better way to extract the excel data?
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,102,291
Messages
5,485,964
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top