A cleaner way to import files from a SharePoint folder with a Power Query function

Import files from SharePoint folder with Power Query into Power BI
In today's video, I am going to show you how to import files that are stored in a SharePoint folder or library in Power BI using Power Query.

To do that we will create a function that cleans a typical file and then reuse that function to apply to any existing or new file added to the library.

Chapters:
00:00 Intro
00:50 Get data from sharepoint online list
01:18 Error when connecting power query to sharepoint list
02:00 Change Sharepoint.Tables to Sharepoint.Files
02:20 Clean excel file from sharepoint
03:20 Create a function to clean excel files in sharepoint
06:00 Add function to all files in sharepoint
07:00 Add additional files to test function in sharepoint
Done!

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[JackOfTrades]

This is awesome. I've been doing it without the function and it's very messy. I'm going to save and share this video with my team. This is incredibly valuable.

[henriknymann]

You are simply a life saver... As self taught in Power BI, your videos have helped me gain enough knowledge to be able to create complex reports to be used by hundreds if not thousands..

[lenzypetty]

Great explanation. I used the SharePoint Folder connector to connect to my Online SharePoint Folders instead of the SharePoint List Connector. As a result, I was able to start at 2:22minute mark in the video.

[dandysixties]

I keep coming back to this video because is probably the MOST USEFUL for me of all videos out there lol

[MusicPancho]

April 2021 - Works for me! I had to adjust the formula in my power query when importing, had to write ", [ApiVersion = 15]" after changing Tables to Files at 2:12 :)

[markmcc]

absolute life saver! this has had me stumped for 2 weeks or more, thank you!

[thundercatshooo]

This was my first time importing from a SharePoint folder. You made this look simple. Thank you soo much.

[mozgusify]

Thank you Ruth, I'm beginning with power query and PowerBI and your videos are amazing.

[paulexcellence]

I honestly liked the way you presented this video, but also the effectiveness of this module. You are the best

[JeffAtkins]

This is enormously helpful. I've watched and followed along more than once.

[frankverabarces]

Gracias! This video has literally changed my life!

[jameschurch]

Still using this method years later, thank you so much!

[RedzGaming]

Thank you for your help, now i can navigate through sharepoint folders smoothly through the PowerQuery

[alagator]

Thank you so much. Great explanations and it works perfectly!

[faizanalimohammed]

Man I don't know what to say this is awesome.
Thank you so much, you saved me doing a lot of steps.

[Crysteps]

Ruth,
Thank You SO MUCH!
I learned a fantastic trick today from You and already applied it to my own datasets.
This will save a ton of time for my team.

Thank You!

[alexkim]

Brilliant as always. I knew I can always refer to your videos when I'm stuck at work! This is gonna be my first time doing this. Excited to try that out now!

[albertomendozaa]

A very clever and elegant solutions, love it, love your content, all of it!

[ampung]

Thank you sooo much!! This is the 2nd times I return back to your tutorial again. Your video is my favorite and meaningful and powerful for me (and many people also :)

[KevinMichaelCarroll]

This is fantastic and will save me a lot of time. I was also able to tweak the approach slightly to allow for file gathering across sub-folders by using Text.Contains and adding a FilePath parameter to the function in addition to FileName.