Power BI
NewWorkspace Level Parameters for use in Dataflows (and/or) Dataset Parameter Configuration
Daniel Rolfe on 07 Mar 2023 21:07:12
So the use case is -
A Power BI Premium Capacity hosting workspaces dedicated to an individual "client".
Dataflow has Parameters to define certain configuration items in its data gathering process.
Datasets connect to Dataflow Entities
It would be awesome if we were able to set Global Parameters that can be harnessed by the M-Query in a similar fashion that Dataflow Parameters / Dataset Parameters are harnessed.
Theoretical Example:
Client A has a tenant ID of ABCD-1234-xxxx (some guid)
Client B has a tenant ID of DEFG-4567-xxxx (some other guid)
Workspace Global Parameter added for "Tenant_ID"
In Dataflow:
M Query Parameter value =
WorkspaceParams.Tenant_ID meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type text]