Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power Query Essentials: Managing Advanced Data Connections
New
1 students

Power Query Essentials: Managing Advanced Data Connections

Connect, combine, and auto-refresh data from multiple sources in seconds.
Created bySimon Sez IT
Last updated 7/2026
English

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.

Course content

2 sections • 13 lectures • 1h 5m total length

  • Course Welcome1:46
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Import Multiple Files from a Folder6:54
  • Connect to Data in Another Excel Workbook8:16
  • Get Data from the Web8:58
  • Checking and Managing Data Source Locations3:53
  • Troubleshooting Import Errors6:42
  • Section Quiz

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.

Description

This course includes downloadable course instructor files and exercise files to work with and follow along.


Power Query Essentials: Managing Advanced Data Connections teaches you how to build data connections that update themselves instead of forcing you to copy and paste every week. This course turns Power Query from a mystery button into a tool you use with confidence, in both Excel and Power BI.


You start with the problems that slow down everyday reporting: dozens of separate files, spreadsheets that go stale the moment someone emails a copy, and connections that break the instant a file gets moved or renamed. These are the exact issues that push people back into manual data entry.


From there, you build practical skills. You learn to combine whole folders of files into one dataset, connect to SharePoint and live web pages, and decide whether data should load as a table, a PivotTable, or straight into the Data Model. You also learn to read error messages and fix broken connections using Data Source Settings.


Each skill is grounded in a real situation. You learn how to merge weekly inventory files into one report, split a messy product description into clean columns with Column From Examples, and set up a central file so your team stops working from outdated copies. You also organize source folders so imports stay clean as files pile up.


By the end, you will be able to build a refreshable reporting pipeline from scratch and trust the numbers it produces. This course suits analysts, report builders, and anyone in Excel or Power BI who is tired of rebuilding the same spreadsheet every month.


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.


This course includes:

  1. 65 minutes of video tutorials

  2. 10 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Excel users who want to automate repetitive data imports and stop copying and pasting data.
  • Business analysts who need to combine and refresh data from multiple files and sources.
  • Power BI users who want to create reliable, refreshable data connections.
  • Report builders who regularly work with recurring reports and dashboards.
  • Anyone who wants to organize, clean, and combine data more efficiently using Power Query.

Report abuse