You have the following three versions of an Azure SQL database: - Test - Production - Development You have a dataset that uses the development database as a data source. You need to configure the…

Question

Options

• ACreate a JSON file that contains the database server names. Import the JSON file to the dataset.
• BCreate a parameter and update the queries to use the parameter.
• CCreate a query for each database server and hide the development tables.
• DSet the data source privacy level to Organizational and use the ReplaceValue Power Query M

• A
  13% (2)
• B
  80% (12)
• D
  7% (1)

Explanation

Power Query parameters allow you to define a named, typed value (e.g., the database server name) that all queries reference. Once published to the Power BI service, dataset settings expose a 'Parameters' section where users can update the parameter value without editing the query code - making environment switching trivial from powerbi.com. Importing a JSON file (A) adds complexity without the built-in service UI. Creating separate queries per environment (C) bloats the model and doesn't provide a clean switching mechanism. ReplaceValue M function (D) is a query-level transformation, not a configurable parameter exposed in the service.

No community discussion yet for this question.