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!

Here you can download all the pbix files: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

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

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#CURBAL #SUBSCRIBE