MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query



All 6 files and folders and text files used in video are available in this zipped folder: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/MSPTDA-20-DownloadAllFiles.zip
Download file individually at class web site: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/DataModeling.htm
pfd notes for Video #20: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/020-MSPTDA-PQParameterDataSource.pdf

In this video learn about how to create a variable or parameter for a data source path (folder path in this video) in Excel Power Query and in Power BI Desktop Power Query. Learn about Query References other queries or steps, so it may not directly access a data source Error in Power BI.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:23) Introduction
2. (02:36) Excel Power Query Example of Parameter for Data Source / Folder Path
3. (8:48) Power BI Example of Parameter for Data Source / Folder Path
4. (10:23) Summary

Source