All 6 files and folders and text files used in video are available in this zipped folder: http://bit.ly/2V31jnl
Download file individually at class web site: http://bit.ly/2GF25Ni
pfd notes for Video #20: http://bit.ly/2UY2mVs
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