How to combine multiple files from SharePoint folder in Power BI

by

In this Power BI Tutorial, we are going to explore How to Combine Multiple Files From SharePoint In Power BI.

Subscribe to EnjoySharePoint YouTube channel for more FREE videos.

Combine multiple files from SharePoint folder in Power BI

This is the scenario where I have a SharePoint site under site. I just want to connect some of the folders in order to retrieve my data in order to process my data and form the beautiful reports, dashboards.

Under the Shared Folder on DemoSite, I have multiple files. So I want to Combine all these files and retrieve data into a single file in Power BI.

power bi combine multiple files from SharePoint folder
Combine multiple files from SharePoint folder in Power BI

Now we need to click Get Data and then more and in the search, we will just write SharePoint.

Otherwise, we need to search in different categories, so the very first option we have here is a SharePoint Folder we will select and we will click OK

power bi combine multiple files from SharePoint folder
Combine multiple files from SharePoint folder in Power BI
power bi combine multiple files from SharePoint folder
Combine multiple files from SharePoint folder in Power BI

We will now provide the SharePoint folder path which we already copied so you’ll paste here OK. 

https://enjoysharepointsky.sharepoint.com/sites/DemoSite/
power bi combine multiple files from SharePoint folder
How to Combine multiple files from SharePoint folder in Power BI

Now in the below screen, it’s asking us Sharepoint Credentials. So in order to access files, we need to provide by selecting Microsoft account.

combine multiple files from SharePoint folder power bi
power bi combine multiple files
combine multiple files from SharePoint folder power bi

Once we are successfully connected to the Site we will click on Edit, it will open the query editor.

power bi combine multiple files from SharePoint folder
power bi combine multiple files from SharePoint folder

Now we need to filter our data, so we need to select the Name column and filter the files which are required.

combine multiple files from SharePoint folder power bi
combine multiple files from folder power query
power bi combine multiple files from SharePoint folder
combine multiple files from folder power query

Next step in order to combine files, we need to select Content (first column) and select the data and click OK.

combine multiple files from SharePoint folder power bi
combine multiple files from folder power query

After that, we will just give some meaningful names to our sheet data as Interest rates and click on Close & apply.

power bi combine multiple files from SharePoint folder
How to combine multiple files from folder power query

Once all the changes applied successfully, you will have your combined data as shown below. Now you can process your data the way you want.

power bi combine multiple files from SharePoint folder
combine multiple files from folder power query
power bi combine multiple files from SharePoint folder
combine multiple files from folder power query

You may like the following Power BI tutorials:

In this tutorial, we learned how to combine multiple files from SharePoint in Microsoft Power BI.

>