Power BI | Parameters exercise | Power BI Dynamic connection string

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend the course listed below!

Software ==> Power BI  (88 exercises)
Version ==> Latest update
Topic ==> Parameters  (5 exercises)
Level ==> Harder than average
Course ==> Advanced Power BI
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

In the above folder are 3 Excel files containing information about the tallest buildings in various countries. The aim is to be able to switch between viewing the top 10 from each file by switching which is connected:

Power BI Query Editor Dynamic Connection string

To start with either connect to the UK file from scratch or else open the PBIX file in the above folder.

We need to store the location of each file in a parameter so we can switch between them. Create a parameter and list the file names:

Power BI Query Editor Dynamic Connection string

This will create a drop down letting users choose which file to connect to.

Now access the Advanced Editor from the Home tab within the Query Editor and replace the file name with your parameter:

Power BI Query Editor Dynamic Connection string

The & is used to concatenate the string connection with the value inside the parameter.

Exit Query Editor and then use Edit Parameters under Edit Queries to switch to a different file:

Power BI Query Editor Dynamic Connection string

You may need to click Apply changes to finish loading the data.

 

Optionally save this as Tall, Taller, Tallest and then close it down.

This page has 0 threads Add post