Default value for parameter in workspace

[eirika]

I have 2 customers with one wokspace each.

The report I publish to both workspaces has a paramter named CustomerID that is used to filter in the SQL to only include data related to the Customer in each workspace. When I publish the report I need to go to settings on the dataset to configure the Parameter to the correct value for each workspace.

If I need to deploy 10 reports to each workspace, then I need to configure the CustomerID for each report.

Is there any way to set this variable with a default value for the workspace?

This way I would be able to say that variable CustomerID in Workspace_1 should default to 1 for all reports, and CustomerID in Workspace_2 should default to 2 for all reports.

[conorh-dev]

I have a similar requirement and would love to see an easy solution to implement and maintain this. 

It seems like the ideal solution would be able to set the parameter values on the workspace so that when a generic, parameterised report or dataflow is deployed to a workspace that it would just read in the parameter values on that workspace. This does not appear to be how this works in PowerBI though. 

The way I am going to approach it now looks like we will parameterise all the reports to point to a named dataset so that when we deploy between workspaces we will only need to update the parameter values on the dataset, based on some kind of convention on the workspace name maybe, with Azure Automation or some other kind of hook.

I found this earlier and will need to look through it but I hope there is a much easier solution to doing all of this because it seems like a lot of additional work to achieve what seems like a simple ask to maintain multiple customer workspaces from one development/production workspace. 

Overview of Power BI deployment pipelines - Power BI | Microsoft Learn

[eirika]

Hi Otravers,

Thanks for your reply. This is a nice way to increase performance but it will not solve my issue. I already have the parameter in the query. My report is deployed to 2 different workspaces where I need to set the parameter to different values. When I create a new report this will include the same parameter and when the new report is deployed I need to edit the dataset settings to set the parameter value once again for each workspace. But the name and value of the parameter is equal for all reports in the same workspace.

A realy nice feature would be to set a workspace paramter and if a report in the workspace uses the same name as the workspace parameter it will get that value.

[otravers]

Look into dynamic M parameters:

- https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

- https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-powe...