PowerBI Consolidate Multiple files From SharePoint Folder
Power BI
May 6, 2023 8:00 AM

PowerBI Consolidate Multiple files From SharePoint Folder

by HubSite 365 about Wyn Hopkins [MVP]

Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers

Data AnalyticsPower BI

Consolidate Multiple files From SharePoint Folder and how to debug and avoid errors

PowerBI Consolidate Multiple files From SharePoint Folder allows you to easily combine multiple files into one single report. The user can connect to a SharePoint folder to analyze, transform, and combine all the data within the folder into a single data model. This feature enables the user to create reports that contain data from multiple sources and view them in a single PowerBI report. The user can also create visualizations from the combined data and share the report with colleagues.

  • 00:00 Intro
  • 00:42 The Setup - Getting the correct folder path
  • 01:54 Change SharePoint.Files to SharePoint.Contents
  • 05:49 Adding new files (including problem files)
  • 07:42 Identifying the problem files
  • 11:15 Changing the Folder Path with the Split Out technique

In this blog post, we'll show you how, with the newest version of the Power BI Desktop and Power Query for Excel, you can combine multiple data from Excel files ...

Jan 12, 2021 — In this Power BI Tutorial, we are going to explore How to combine data from multiple files from the SharePoint folder in Power BI.

May 16, 2022 — If your files are in a OneDrive or a SharePoint folder, the process is virtually the same, but subtly different. You need the right path for ...

Jan 23, 2023 — If your folder contains only the files you want and nothing else, you can go ahead and select Combine & Load. If you need to filter out files or ...