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
9 months ago
Wait, can you really just replace all those references like that?
upvoted 0 times
...
Malika
9 months ago
Totally agree, makes it way easier to manage.
upvoted 0 times
...
Tina
9 months ago
Not sure if that's the best approach, though.
upvoted 0 times
...
Dalene
9 months ago
Yup, that's how you avoid hard-coding issues!
upvoted 0 times
...
Oliva
9 months ago
That's a solid way to streamline the queries!
upvoted 0 times
...
Pansy
10 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
10 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
10 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
10 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
11 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
11 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
11 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
11 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
1 year 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
1 year 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
1 year ago
This is the correct answer. Parameterizing the data source is a best practice for sure.
upvoted 0 times
...
Tanja
1 year ago
Yes, using a parameter like DataSourceExcel will make the code more maintainable.
upvoted 0 times
...
Antione
1 year ago
No, because hard-coding the file location in each query definition provides more control.
upvoted 0 times
...
Alisha
1 year 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
1 year ago
Absolutely, it's a smart way to manage the file path
upvoted 0 times
...
Wilda
1 year ago
Agreed, it will definitely save time and effort
upvoted 0 times
...
Glen
1 year 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
1 year 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
1 year ago
User 1: A) Yes
upvoted 0 times
...
...

Save Cancel