Скачать с ютуб A cleaner way to import files from a SharePoint folder with a Power Query function в хорошем качестве

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!    / @curbalen   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