Forum Discussion

QQQ's avatar
QQQ
Advocate II
9 years ago

Combine Multiple Files in Folder for Power Query

I am able to combine multiple .csv files from same folder and create query.   When I attempt this it only imports the first excel file.   And when I list all source file names I get [Expression.E...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

QQQ,

 

I have tested it on my local environment, I can combine all the CSV file with out any issue. Could you please provide us more detail steps, so that we can make further analysis.
https://www.youtube.com/watch?v=pMQK1Zcc9jw

 

Regards,

Charlie Liao

  • QQQ's avatar
    QQQ
    Advocate II
    9 years ago

    I can also combine all .csv files without issue.

     

    But I am unable to combine all .xlsx files without issue.