[QUESTION] Is it possible to get dynamically the workspace name in the parameter.yml file

[cfk237]

What is the question?

I have a composite semantic model using a second semantic model in the same workspace, when the deployment is done, the composite semantic model is still pointing on the semantic model in previous environment and not in the targetted environment.
How to replace with the parameter.yml the workspace name during the deployment in the composite semantic model expressions.tmdl file ?

Context

In a workspace, I have a semantic model A (Direct lake on OneLake) and a composite semantic model B in mixed mode (using as sources the semantic model A in Direct Query and a dataflow).
The expressions.tmdl of composite semantic model B in the repo looks like below.
I want to replace "WORKSPACE NAME [DEV]" by "WORKSPACE TARGETTED NAME [ENV]".
Moreover, we will probably need to preserve encoding of characters like space or []

expression 'DirectQuery to AS - Model Direct Lake' =
		let
		    Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/WORKSPACE%20-%20NAME%20%5BDEV%5D", "Model Direct Lake"),
		    Cubes = Table.Combine(Source[Data]),
		    Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
		in
		    Cube
	lineageTag: 219043cb-c4fa-40e6-8a01-12bf2eaf045f

	annotation PBI_IncludeFutureArtifacts = True

Library Version

0.3.1

Operating System

Windows

Have you checked the documentation?

• I have searched existing GitHub issues
• I have reviewed the fabric-cicd documentation

Additional Information

No response

[shirasassoon]

/triaged

@cfk237 Thanks for your question. Have you tried a basic find/replace, something like the following (file filters can be different):

find_replace:
    - find_value: "WORKSPACE%20-%20NAME%20%5BDEV%5D"
      replace_value:
          PPE: "WORKSPACE%20-%20NAME%20%5BPPE%5D"
          PROD: "WORKSPACE%20-%20NAME%20%5BPROD%5D"
      item_type: "SemanticModel"
      item_name: "Composite Semantic Model B"
      file_path: "/Composite Semantic Model B.SemanticModel/definition/expressions.tmdl"

[cfk237]

Hi @shirasassoon , your proposal will work like just replacing the environment value.

find_replace:
    - find_value: "DEV"
      replace_value:
          PPE: "PPE"
          PROD: "PROD"
      item_type: "SemanticModel"
      item_name: "Composite Semantic Model B"
      file_path: "/Composite Semantic Model B.SemanticModel/definition/expressions.tmdl"

But if I need to change the targeted workspace name prefix (WORKSPACE NAME FEATURE for e.g.), this mean edit the parameter file to set the targeted name. which is why I'm wondering if there's a way to dynamically retrieve the name of the deployed workspace, which would provide more flexibility.
If not, I think that this could be an enhancement to add in the roadmap.

[shirasassoon]

@cfk237 Dynamic retrieval of the workspace name is not supported today. Can you elaborate on why this would be of value to you?

[shirasassoon]

/needinfo

[cfk237]

Hi @shirasassoon,
Sorry for the delay. As I mentioned earlier, the goal is to streamline deployments without having to worry about whether the semantic model is pointing to the correct source in the correct workspace.

In my current pipeline, the target workspace is defined by a pipeline parameter, and we follow a naming convention. This simplifies the deployment logic when moving from one environment to another.

However, if I need to change the target workspace name — which can be considered similar to branching out — I want to be able to specify the workspace name explicitly. At the same time, all semantic models that reference this workspace should be updated dynamically.

Without this capability, I would need to manually rebind each semantic model to the correct source.

[microsoft-github-policy-service]

Thank you for replying with additional information, @cfk237.
A member of the Fabric CICD team will continue reviewing this issue.