nerdexam
Microsoft

PL-300 · Question #16

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…

The correct answer is B. No. 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.

Submitted by thandi_sa· Apr 18, 2026Prepare the data

Question

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?

Options

  • AYes
  • BNo

How the community answered

(35 responses)
  • A
    29% (10)
  • B
    71% (25)

Explanation

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.

Topics

#Power Query#Parameters#M Language#Data Source Configuration

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice