Question
You have the Azure SQL databases shown in the following table.
| Name | Stage | Server URL |
|---|---|---|
| db-powerbi-dev | Development | dev.database.windows.net |
| db-powerbi-uat | Test | uat.database.windows.net |
| db-powerbi-prod | Production | prod.database.windows.net |
You plan to build a single PBIX file to meet the following requirements:
- Data must be consumed from the database that corresponds to each stage of the development lifecycle.
- Power BI deployment pipelines must NOT be used.
- The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
Explanation
Create: a single Power Query parameter that identifies the stage (for example dev, uat or prod) is enough, because the server URL and the database name both follow the same naming pattern and can be built from that one value in the source step. Switching stages then means changing one parameter value, which keeps administrative effort lowest; separate parameters per server, database or stage add values that must be kept in sync. Parameter type: server names, database names and stage identifiers are strings, so the parameter is of type Text; True/False and Decimal number cannot hold these values.
