How can I get the data from excel files from a folder for a Power BI Query?

Hello Anonymous 

you can click on the double arrows on the content-column (this is the content of the Excel-files). Power BI opens an assistant to choose your sheet name. Afterwards Power BI creates a custom function to read from every file (uses all the time the same sheet name).

After that you can go to the query "Transform Sample File" to change the steps applied to every file (here you can choose promote headers, or whatever you want to apply to every the choosen sheet-name of every file

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Anonymous 

You cannot combine multiple excel files with different schema. For example, you can combine the first two files but not with third file.

The combined result is following, if you use the first file of combination. 

With different schema, you can only import excel files separately into power bi desktop, then do further transformation. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.