The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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.

Table of contents:

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

Watch the tutorial:

A cleaner way to import files from a  SharePoint folder with a Power Query function
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents