Skip to main content

Power BI

New

Workspace Level Parameters for use in Dataflows (and/or) Dataset Parameter Configuration

Vote (1) Share
Daniel Rolfe's profile image

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]