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
Видео MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query канала excelisfun
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
Видео MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query канала excelisfun
Excelisfun Highline College Data Analysis Business Intelligence BI 348 Mike Girvin Microsoft Power Tools for Data Analysis 20 Variable Folder Path Power Query Power BI Desktop Power BI Formula.Firewall Error Query References other queries or steps Easily add query parameters to your source paths Set up Query Parameters to avoid hardcoded paths Dynamic folder location Parameter Folder Path may not directly access data source Please re-build this data combination
Комментарии отсутствуют
Информация о видео
27 апреля 2019 г. 20:21:28
00:11:07
Другие видео канала
