Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
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