New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Avoid hardcoded paths in Power Query

With the release of the April update (2016), Power BI allows the use of parameters and in this video I will show you how to configure them to avoid using hardcoded paths when connecting to file sources in your computer.

Table of contents:

00:00 Intro
01:00 Why hardcoded paths are problematic
01:30 How parameters work
02:30 How to create your own parameters
04:00 Add the parameter to your path
04:45 Test the parameter

Watch the tutorial

Set up Query Parameters to avoid hardcoded paths in Power Query

Was this helpful?
Previous Advanced setting to add query parameters to your source paths in Power Query
Next Use query parameters to filter your Power BI reports

Reader Interactions

Let us know your thoughts...

Table of Contents