The Best Way To Import Data From A Folder To Query Editor Without Getting Any Errors

Well this usually happens as you are hitting 'Combine & Transform' Letting Power BI doing all the work 
well, Don't do this again!

Have you ever got this annoying error when importing data from a folder on Power BI or Excel?

Here's the best way to do it:

1- Click 'Transform Data' Instead Of 'Combine & Transform'

This will let you do all the work from the start, don't be afraid it is so easy

2- Step By Step 

1- That's our contents

2- We don't need the other information right now

3- Let's add a custom column

4- This is our magic word that will extract our data nice and good 

5- That's our main column so rewove the others

6- Extract the sheets and tables within our excel files

7- That's an important note:
you will have this if your data is in tables within your files 
the editor reads it twice, once as a sheet and once as a table so you will have to only select one of them

8- Now after filtering to only tables we only want the data column

9- Expand your data -Don't forget to uncheck the shown box-

10- Here's your data without any errors

Regards.