How to combine multiple files from SharePoint folder in Power BI

Subscribe to EnjoySharePoint YouTube channel for more FREE videos. In this Power BI Tutorial, we are going to explore How to Combine Multiple Files From SharePoint In Power BI.

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

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

power bi combine multiple files from SharePoint folder

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

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
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

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
power bi combine multiple files from SharePoint folder

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

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

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
power bi combine multiple files from SharePoint folder

You may like the following Power BI tutorials:

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

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

Bhawana Rathore

Hello Everyone!! I am Bhawana a SharePoint MVP and having about 8+ years of SharePoint experience as well as in .Net technologies . I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools . Now exploring more in SharePoint 2016 :) Hope here I can contribute and share my knowledge to the fullest. As I believe "There is no wealth like knowledge, and no poverty like ignorance"

>