Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 2 Question 69 Discussion

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen,You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.Does this meet the goal?
A) Yes
B) No

Microsoft PL-300 Exam - Topic 2 Question 69 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 69
Topic #: 2
[All PL-300 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen,

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

Does this meet the goal?

Show Suggested Answer Hide Answer
Suggested Answer: A

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.


https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

by Nickole at Jul 07, 2025, 05:32 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Chun
7 months ago
Wait, can you really just replace all those references like that?
upvoted 0 times
...
Malika
7 months ago
Totally agree, makes it way easier to manage.
upvoted 0 times
...
Tina
7 months ago
Not sure if that's the best approach, though.
upvoted 0 times
...
Dalene
7 months ago
Yup, that's how you avoid hard-coding issues!
upvoted 0 times
...
Oliva
7 months ago
That's a solid way to streamline the queries!
upvoted 0 times
...
Pansy
8 months ago
I feel like this is similar to another question we did, and I think using the parameter should work as intended.
upvoted 0 times
...
Leonie
8 months ago
I'm a bit confused. I remember something about needing to ensure all queries reference the parameter correctly, but what if one doesn't?
upvoted 0 times
...
Samira
8 months ago
This reminds me of a practice question where we had to use parameters in Power Query. I believe this solution does meet the goal.
upvoted 0 times
...
Brande
8 months ago
I think replacing the hard-coded references with the parameter is the right approach, but I'm not entirely sure if it covers all scenarios.
upvoted 0 times
...
Chun
9 months ago
Wait, what do they mean by "you will NOT be able to return to it"? I better make sure I have the right approach before submitting my answer.
upvoted 0 times
...
Fernanda
9 months ago
Okay, I think I've got it. Replacing the file references with the parameter should meet the goal, but I'll double-check the code just to be sure.
upvoted 0 times
...
Tamala
9 months ago
Hmm, I'm not sure if that's the complete solution. The question mentions there might be multiple correct answers, so I'll need to think this through carefully.
upvoted 0 times
...
Malinda
9 months ago
This looks straightforward. I'll just replace the hard-coded file references with the DataSourceExcel parameter and submit my answer.
upvoted 0 times
...
Jamal
11 months ago
I was just about to try and create a flow to automate the file path updates. But this parameter approach is way cleaner. Nice one!
upvoted 0 times
...
Melvin
11 months ago
Haha, finally a question where the solution isn't to just use Power Automate. This one's actually about Power Query, nice!
upvoted 0 times
...
Lyndia
11 months ago
This is the correct answer. Parameterizing the data source is a best practice for sure.
upvoted 0 times
...
Tanja
11 months ago
Yes, using a parameter like DataSourceExcel will make the code more maintainable.
upvoted 0 times
...
Antione
12 months ago
No, because hard-coding the file location in each query definition provides more control.
upvoted 0 times
...
Alisha
12 months ago
Yes, because using a parameter will make it easier to update the file location in the future.
upvoted 0 times
...
Rebecka
1 year ago
Totally, this is a great solution. No more manually updating the file path in every query definition. Genius!
upvoted 0 times
Magdalene
12 months ago
Absolutely, it's a smart way to manage the file path
upvoted 0 times
...
Wilda
12 months ago
Agreed, it will definitely save time and effort
upvoted 0 times
...
Glen
12 months ago
Yes
upvoted 0 times
...
...
Rebbeca
1 year ago
Yep, that's the way to go! Replacing the hard-coded file location with a parameter makes the code much more flexible and maintainable.
upvoted 0 times
Jennifer
11 months ago
User 2: Yep, that's the way to go! Replacing the hard-coded file location with a parameter makes the code much more flexible and maintainable.
upvoted 0 times
...
Gearldine
11 months ago
User 1: A) Yes
upvoted 0 times
...
...

Save Cancel