Power Query: Load Folder Data with Custom Functions and Irregular Tables
6:31
YouTubeOmidBI
Power Query: Load Folder Data with Custom Functions and Irregular Tables
Learn how to load and transform data from a folder in Power Query—even when the source files contain messy structures with values outside the defined table range! In this tutorial, you'll discover how to: Load multiple Excel files from a folder Handle inconsistent layouts (e.g. extra headers or footnotes outside table range) Use Power Query ...
已浏览 612 次7 个月之前
Power Query Basics
Power Query - Beginner to PRO Masterclass in 30 minutes
35:17
Power Query - Beginner to PRO Masterclass in 30 minutes
YouTubeChandoo
已浏览 41.3万 次2024年8月13日
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
28:07
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
YouTubeJosh Aharonoff (Your CFO
已浏览 21.1万 次2025年1月15日
How to use Power Query - Microsoft Excel Tutorial
36:48
How to use Power Query - Microsoft Excel Tutorial
YouTubeTeacher's Tech
已浏览 35.7万 次2022年11月28日
热门视频
Power Query for Beginners: Clean, Fold & Load Fast
15:19
Power Query for Beginners: Clean, Fold & Load Fast
YouTubeGuy in a Cube
已浏览 2.1万 次5 个月之前
Dynamic folder paths in Power Query | Stop hard-coding file paths | Microsoft Excel
13:35
Dynamic folder paths in Power Query | Stop hard-coding file paths | Microsoft Excel
YouTubeGraciela @ Power GI
已浏览 1979 次7 个月之前
How to Combine Files from a Folder with Power Query in Excel 365
6:52
How to Combine Files from a Folder with Power Query in Excel 365
YouTubeSimon Sez IT
已浏览 7247 次2024年10月2日
Power Query Advanced Techniques
Advanced Power Query Techniques: Join, Append, XML, JSON, Date & Time Mastery | Get Data From | #20
1:34:11
Advanced Power Query Techniques: Join, Append, XML, JSON, Date & Time Mastery | Get Data From | #20
YouTubeCoding Analytics
已浏览 28 次2 周前
5 Advanced Power Query Tricks Every Data Analyst Should Know | PBI & Excel Users | Download PBIX
29:40
5 Advanced Power Query Tricks Every Data Analyst Should Know | PBI & Excel Users | Download PBIX
YouTubeAnalytical Guy
已浏览 185 次3 周前
Power Query Tutorial - Beginner to Advanced [Full Course]
1:54:31
Power Query Tutorial - Beginner to Advanced [Full Course]
YouTubePivotalstats
已浏览 1.1万 次6 个月之前
Power Query for Beginners: Clean, Fold & Load Fast
15:19
Power Query for Beginners: Clean, Fold & Load Fast
已浏览 2.1万 次5 个月之前
YouTubeGuy in a Cube
Dynamic folder paths in Power Query | Stop hard-coding file paths | Microsoft Excel
13:35
Dynamic folder paths in Power Query | Stop hard-coding file path…
已浏览 1979 次7 个月之前
YouTubeGraciela @ Power GI
How to Combine Files from a Folder with Power Query in Excel 365
6:52
在视频中查找 05:07Removing Source Name Column and Checking Data Types
How to Combine Files from a Folder with Power Query in Excel 365
已浏览 7247 次2024年10月2日
YouTubeSimon Sez IT
Power Query - Data from many folders with Single Query
12:01
在视频中查找 05:02Importing Data from Multiple Folders and Files Dynamically
Power Query - Data from many folders with Single Query
已浏览 2.4万 次2023年2月13日
YouTubeBA Sensei
Power Query - Beginner to PRO Masterclass in 30 minutes
35:17
Power Query - Beginner to PRO Masterclass in 30 minutes
已浏览 41.3万 次2024年8月13日
YouTubeChandoo
Get Data From SharePoint or OneDrive with Power Query - Demystified!
14:00
在视频中查找 04:02Getting Data from a SharePoint Folder
Get Data From SharePoint or OneDrive with Power Query - Dem…
已浏览 26.7万 次2021年3月18日
YouTubeMyOnlineTrainingHub
Combine Files from a Folder with Power Query the RIGHT WAY!
10:18
在视频中查找 02:17Using Power Query for Combined Files
Combine Files from a Folder with Power Query the RIGHT WAY!
已浏览 34.9万 次2023年5月23日
YouTubeMyOnlineTrainingHub
4:40
在视频中查找 00:16Getting Data from File
Get data from the latest file in a folder with Power Query | Excel Of…
已浏览 2.7万 次2023年11月29日
YouTubeExcel Off The Grid
10:15
Power BI Get Data from SharePoint Folder using Power Query
已浏览 1万 次10 个月之前
YouTubeRADACAD
13:18
Power Query Custom Function with Parameter to Get & Transform Mul…
已浏览 1.8万 次2 个月之前
YouTubeexcelisfun
6:34
在视频中查找 01:16Duplicating File Name Query
Powerful trick to get data from any folder in Excel (works even after r…
已浏览 2.1万 次2024年4月30日
YouTubeChandoo
32:52
Unlock the FULL Potential of Power Query with SharePoint Folder Con…
已浏览 388 次5 个月之前
YouTubeChange tips and tools
18:05
Small Power Query Habits That Change Everything
已浏览 2.7万 次4 个月之前
YouTubeGoodly
7:31
How to Get Data from Folder in Excel on Mac Using Power Query …
已浏览 1万 次2024年12月28日
YouTubeZero Analyst
25:56
13 Mind Blowing Power Query Features to Automate Your Excel …
已浏览 10.1万 次11 个月之前
YouTubeJosh Aharonoff (Your CFO Guy)
5:48
How to copy a power query and use it on another folder
已浏览 1286 次2024年10月16日
YouTubeKarina Adcock
4:22
在视频中查找 02:57Replacing the Source Query with the New Relative Path Query
Power Query: The Relative Path Hack You Didn't Know About
已浏览 1.1万 次2024年8月24日
YouTubeHow to Learn Excel
5:59
在视频中查找 04:37Method 7: Changing Source State in Official Power Query Parameter
7 METHODS to change source data location in Power Query | Excel Of…
已浏览 4.1万 次2022年12月9日
YouTubeExcel Off The Grid
8:44
在视频中查找 00:45Creating a Backup Query
How to change the source data connector in Power Query | Excel …
已浏览 1.5万 次2024年5月9日
YouTubeExcel Off The Grid
13:21
SharePoint Files or Folder Contents in Power BI using Power Query
已浏览 7187 次10 个月之前
YouTubeRADACAD
21:52
Power Query động: Lấy dữ liệu từ Folder/file với đường dẫn trong ô …
已浏览 9063 次7 个月之前
YouTubeGà Excel
21:00
Combine Data from Multiple Sheets into a Single Excel File | Most Dyn…
已浏览 3.5万 次2024年10月23日
YouTubeGoodly
1:52
How to Change Source File in Power BI (2025) | Update File Path or Dat…
已浏览 573 次6 个月之前
YouTubeDataMinds Academy
5:38
在视频中查找 01:20Opening the Query Editor
INSANE AMAZING Power Query tip to quickly change data sources in …
已浏览 22.7万 次2021年2月25日
YouTubeGuy in a Cube
15:33
Power Query - Query Folding (The key to faster query execution)
已浏览 1.6万 次2024年9月15日
YouTubeBCTI
1:17:08
在视频中查找 12:00Importing Data from CSV Files
How to make dynamic the path to the data source files in Power Que…
已浏览 2.7万 次2022年5月20日
YouTubeCelia Alves - Solve & Excel
12:56
Query Folding in Power BI | Complete Guide
已浏览 1.2万 次2024年3月5日
YouTubePivotalstats
2:54
在视频中查找 00:10What is Data Source Settings?
Power Query Editor : Data Source Settings
已浏览 1498 次2024年3月6日
YouTubeSantosh Pothnak
0:46
在视频中查找 00:40CSV File Explanation
Combine data from multiple excel files in a folder using Power Query
已浏览 1050 次2024年5月16日
YouTubeExcel Bonanza
观看更多视频
静态缩略图占位符