Modifying the Workspace Names is breaking my connections

[julsr]

Hi everyone!

I'm using Deployment Pipelines, and I have 3 workspaces with a prefix on them (i.e., Dev Workspace - Area1, Test Workspace - Area1, Prod Workspace - Area1). When removing the "- Area1" from the name of each workspace the Direct Query and Import connections break with the following error:

"We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permission to access them"

I fixed the previous error by modifying back the Workspace names adding the "- Area1" again, but how could I change them without breaking anything?

Thanks

[v-zhangti]

Hi, @julsr 

You can rename a workspace in a deployment pipeline by unassigning it from the pipeline stage and then assigning it again with the new name. However, this may cause some item connections to be lost or broken, so you need to review and fix them manually after renaming the workspace.
Assign a workspace to a Microsoft Fabric Application lifecycle management (ALM) deployment pipeline ...

You can also use the workspace parameter in the deployment pipeline settings to specify a custom name for each stage. This name will be used as a prefix for the workspace name when deploying to that stage. For example, if you set the workspace parameter to “Dev” for the development stage, the workspace name will be “Dev - Workspace Name”. This way, you can avoid changing the original workspace name and keep the connections intact.

Get started using deployment pipelines, the Fabric Application lifecycle management (ALM) tool - Mic...

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @julsr 

Because it is linked to the actual name that is why it is breaking.

What you could possibly do is to save the PBIX as a PBIP and open it with Visual Studio Code, you should see the connection string in one of the files and there you can change the name?