How To Import Multiple Excel Files With File And Sheet Names In Power BI (Easiest Way) (2026 Guide)
Learn how to efficiently import multiple Excel files into Power BI and automatically include both file names and sheet names as columns for easy data analysis! In this step-by-step tutorial, you'll discover the complete process using Power BI Desktop and Power Query.
Timestamps:
00:00 Intro & Scenario Overview
01:18 Setting up the Folder Connection
03:12 Combining Multiple Excel Files
05:42 Adding File Name as a Column
08:05 Including Sheet Name as a Column
10:10 Transforming and Cleaning Data
12:30 Loading Data into the Power BI Model
13:45 Recap & Final Tips
Supported Platforms: Power BI Desktop (Windows)
Whether you're consolidating reports or automating data imports, this guide has you covered! Don’t forget to like the video if you find it helpful, and subscribe for more Power BI tutorials every week. Have questions? Leave a comment below!
##PowerBI #ExcelImport #PowerBIDesktop #DataAnalytics #PowerQuery #ExcelToPowerBI #DataTransformation #BusinessIntelligence #PowerBITutorial #DataImport