Forum Discussion
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
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
Hello wynhopkins!
Thank you for your help! Turns out I had a few formatting issues, one being the null rows weren't truly blank like you mentioned and the sheet names were not uniform. Thanks to your videos I was able to sort all the errors out. I will definitely be returning to your tutorials in the future, such fantastic resources! Kudos to foodd for the recommendation!
😃Glad to help
