topic Re: execute activities in another workspace? in Pipelines

execute activities in another workspace?

Jerome22 — Thu, 25 Apr 2024 10:28:17 GMT

Hi,

How can I execute activities like a stored procedure but where the warehouse is in another workspace than where my pipeline is stored?

I have a first workspace "Finance data" and a second one "Compliance data".

in the finance data workspace I have a pipeline in place to refresh some data, but I have to refresh data in my warehouse stored in the compliance data workspace.

I want to run a pipeline there or (at least) want to run stored procedures in the warehouse from this second workspace.

how can I do that?

Re: execute activities in another workspace?

Anonymous — Thu, 25 Apr 2024 12:42:02 GMT

Hi Jerome22 ,

Thanks for using Fabric Community.
We don't have direct connection or way to do it. But we have a work around to achieve this goal.

Can you please check the below steps:

Open the Warehouse in another workspace and copy the SQL Connection String -

Add stored procedure and click external connection -

Please paste the SQL Connection String here ans Sign in to Organizational Account -

Please select the warehouse and stored procedure present in different workspace -

Hope this is helpful. Please let me know incase of further queries.

Re: execute activities in another workspace?

Anonymous — Fri, 26 Apr 2024 10:52:42 GMT

Hi Jerome22 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Re: execute activities in another workspace?

Anonymous — Mon, 29 Apr 2024 11:48:54 GMT

Re: execute activities in another workspace?

AnirL — Tue, 22 Jul 2025 15:18:42 GMT

Hi,

I am trying to replicate the process that you have outlined. But unfortunately, I am not sure where you got the "New Connection" interface from. Can you please include the intermediate steps to create the New Connection in Fabric?
Many thanks!!