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...
Here's what I've tried already:
- CSV file conversion
- No leading or trailing spaces in column names
- No non-printable characters in column name
One observation notice, when the column headers row is completed deleted, the import WORK!
Adding a column header one-at-a-time is cumbersome...