New JSON theme available! Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / Avoid hardcoded paths in Power Query
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

< All Topics
Print

Avoid hardcoded paths in Power Query

Posted
Updated
ByRuth Pozuelo Martinez

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?
Tags:
Next Advanced setting to add query parameters to your source paths in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents