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
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Create a Dynamic File Path in Power Query
Change the Power Query source based on a cell value | Data refresh automation | Excel Off The Grid
MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size
Populate a Power BI parameter list using a query
Making data source parameters easy in Power BI Desktop
Get Data From SharePoint or OneDrive with Power Query - Demystified!
MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables
Make it Easier to Share Power Query Relative File Location (XLSX source)
I 💓 GETPIVOTDATA and why you should too!
Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)
Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)
Import Data from Multiple Excel Files from a Folder using Power Query
Easily add query parameters to your source paths in Power Query
INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel
How to make paths dynamic so that Power Query connections work on Dropbox shared files
How to create a relative file path in Power Query
How to Use Power BI Parameters to Create Dynamic Power BI Reports