Combine multiple files from SharePoint folder using Power BI query

Thanks for the shout out foodd 

tina_belcher123 it seems yiur files with 3 rows don't actually only have 3 rows but have lots of empty rows - which look blank.

To check that theory you can open

one of the 3 row files click on row 4, hold shift and press down arrow then delete all rows and save. Then in Power Query that file will not show the nulls.

to avoid having to do that step just choose remove rows- empty rows in power query.

for the best techniques you can check out the 3rd and 4thvideo in my SharePoint playlist here Power Query and SharePoint / OneDrive

https://www.youtube.com/playlist?list=PLlHDyf8d156W_I_ycA7kbfLKAej54p9Un