Скачать или смотреть LESSON 10330 | HOW TO FIX BROKEN FILE PATHS IN POWER QUERY | Complete Free Power Query Course

In this video, I’ll show you how to correctly update file paths in Power Query when your source files are moved or renamed on your computer. You’ll learn how Power Query identifies file paths, what happens when the file location changes, and how to manually fix errors by editing the M code or using Power BI’s built-in data source settings interface. I’ll also walk you through troubleshooting issues caused by changes to file names, paths, or Excel sheet names, and demonstrate best practices for keeping your data sources flexible and error-free. This tutorial is a must-watch if you're working with Power BI or Excel Power Query and want to avoid refresh errors after moving files or renaming sheets.

📈 Get the data packs: https://immalytics.com/packs?utm_sour...

🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  
🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  

💻 For all playlists, visit our website: https://immalytics.com

Chapters
00:00 How to Update Data Sources in Power Query
00:40 Power Query storing the full file path of data sources
01:30 Demonstration: Moving the Excel file to a new folder breaks the connection
02:30 Editing the file path manually in Power Query to restore the link
03:45 Example of moving the file to a completely different directory (Desktop)
05:00 Updating the full path using “Copy as path” and replacing it in the formula
06:00 Easier method: using “Data Source Settings” to browse and update file source
07:10 Handling issues when sheet names are renamed in Excel affecting Power Query

#powerquery #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse