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

preview_player
Показать описание

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
  1. excelisfun
  2. Excelisfun
  3. Highline College
  4. Data Analysis
  5. Business Intelligence
  6. BI 348
Рекомендации по теме
MSPTDA 20: Query 0:11:07

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

MSPTDA 36: How 0:13:23

MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables

MSPTDA 09 Power 1:07:27

MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More

Create Power Query 0:08:07

Create Power Query Parameters For Collaboration And Flexibility.

MSPTDA 21: Power 0:25:13

MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size

Power Query parameters 0:12:29

Power Query parameters | Add flexibility to your queries | Excel Off The Grid

Create a Dynamic 0:13:18

Create a Dynamic File Path in Power Query

Changing Folder Location 0:05:54

Changing Folder Location w/ Query Parameter - Query Editor Tutorial

Create A Parameter 0:06:59

Create A Parameter Table For Your Power Queries

MSPTDA 04: Power 0:32:04

MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set

Adding Parameter in 0:10:49

Adding Parameter in Data Table M Function - Query Editor Tutorial

Easily add query 0:05:12

Easily add query parameters to your source paths in Power Query

Parameter Query || 0:08:45

Parameter Query || Filter Power Query data from Excel

Excel Power Query 0:20:25

Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)

Quickly Change Multiple 0:05:49

Quickly Change Multiple Queries, Same Source in Power Query

MSPTDA 12: Using 0:21:19

MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Count...

MSPTDA 30: Order 0:10:19

MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports

7 METHODS to 0:05:59

7 METHODS to change source data location in Power Query | Excel Off The Grid

Set up Query 0:05:47

Set up Query Parameters to avoid hardcoded paths in Power Query

Sharing Files with 0:05:54

Sharing Files with Power Query Parameter Feature

Making data source 0:03:28

Making data source parameters easy in Power BI Desktop

MSPTDA 07: Power 0:37:39

MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples

Using an Excel 0:03:26

Using an Excel parameter table in Power Query

Power Query and 1:49:33

Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13

Комментарии
Автор

I should not be surprised by now, but once more by jaw dropped while watching one of your tutorial. You got me again, Mike. This is wonderful and fantastically laid out step by step. Clear and simple. Thank you Sir.
😀

jeromeastier
Автор

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

excelisfun
Автор

That's great tip to users, as always great video, clear, simple and useful.

jacksonhz
Автор

That's a great tip Mike! Thank you for a wonderful tutorial.

LeilaGharani
Автор

Thanks Mike - Awesome! Have a quiet week so planning to use to work through a few of your videos.

pravinshingadia
Автор

Thanks Mike!
Just tested it with several exports from the system and it works perfect! Already part of the company report. :)
Really-really useful, thank you!

gabornemeth
Автор

You always have an uncanny way of posting videos that solves a problem I'm currently having. Great video!

jasonn
Автор

Can't thank you enough for this magic trick and the so many tricks I have learnt from you!!

AmrMatar
Автор

Another great video Mike... really appreciate the way you present it. I Love Excel :) Thanks Mike

edge
Автор

you are always wonderful without fail.

mazharhussain
Автор

Thanks Mike.. great tip for dynamic folder paths. Will have to study this further. Thumbs up!

wayneedmondson
Автор

Excel-lent Mike! Thanks for the continued great videos!

chrism
Автор

Thank you so much for your amazing videos!

olegyes
Автор

Thanks a lot it was exactly what I was looking for!

mariaalcala
Автор

Excellent, Mike! I need to use these folder path parameters in files that I've shared in Onedrive, like a stock portfolio. In the Excel file, the user simple picks which computer and a table containing the various paths is used as the parameter and the query works seamlessly.

drsteele
Автор

Great Video as always Mike, thank you so much for

katerina
Автор

Hi Mike, we use the parameter to enable users to use the file on their own Box Sync folder. In the Excel sheet we have this formula: =LEFT(CELL("filename", A1), FIND("[", CELL("filename", A1), 1)-1)&"Data\" which enables the parameter to know the path to the file with the different usernames in the path.

nigelbarrett
Автор

This made my work easier! Thanks for this!

mirrrvelll
Автор

Great!
You helped me a lot.
Thank you very much, and congratulations for the excellent video lesson.

setortransporte
Автор

What a great video that I really was waiting for thank u so much Mr. Mike you are the best

ismailismaili