Udemy - Power Query Essentials - Managing Advanced Data Connectio...

Power Query Essentials: Managing Advanced Data Connections

https://WebToolTip.com

Published 9/2026
Created by Simon Sez IT
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Expert | Genre: eLearning | Language: English | Duration: 13 Lectures ( 1h 5m ) | Size: 732 MB

Connect, combine, and auto-refresh data from multiple sources in seconds.

What you'll learn
⚡ Combine multiple Excel files from a folder into one dataset.
⚡ Connect Power Query to SharePoint folders and web pages.
⚡ Create a single source of truth for shared Excel workbooks.
⚡ Separate large raw data files from lightweight dashboard workbooks.
⚡ Import tabular data directly from live web pages into Excel.
⚡ Fix broken Power Query connections using Data Source Settings.
⚡ Apply error handling to address Power Query data type mismatches.
⚡ Locate and fix query references when column names change.
⚡ Load Power Query data as tables, PivotTables, or connections only.
⚡ Use the Data Model to build relationships between multiple tables.
⚡ Refresh Power BI reports from connected SharePoint and Excel files.
⚡ Structure source data folders for consistent, reliable Power Query imports.

Requirements
❗ Basic Microsoft Excel skills, such as working with worksheets, tables, and formulas.
❗ Familiarity with importing or working with data in Excel is helpful but not required.
❗ A Windows computer with Microsoft Excel 365, Excel 2021, or Excel 2019. Power BI Desktop is recommended for the Power BI lessons.
❗ No prior Power Query experience is required. The course explains each feature step by step.