Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
martin_sperling
Frequent Visitor

Retrieve the Current WorkspaceID in a Dataflow

Hi,

 

I have a dataflow which should work with the same code in various different workspaces. Each workspace relates to a different customer and the data being processed change for each customer. So far I use a parameter in the dataflow for each Workspace. But I have to change this parameter manually. When I update the code of the dataflow, I need to copy and paste the new code into the dataflow, which overrides the parameter as well, so I have to change the parameter again. 

 

Is there a way to make this dynamically, e.g. that I would fetch the current URL aka WorkspaceID in PowerQuery, which I can then link to the customer through a mapping table. Something linke Current.Website or Current.Workspace? 

 

Any ideas?


Many Thanks. 

2 REPLIES 2
martin_sperling
Frequent Visitor

Hey Henry, thanks for your reply. In a nutshell: I want the WorkspaceID to be fetched into a Dataflow, whether as a parameter or as a table entry. And this should work dynamically, so that whenever I copy und paste the Dataflow into another workspace, the WorkspaceID will be updated automatically by the Dataflow itself. Hope this helps.

 

Thanks for your support!

v-henryk-mstf
Community Support
Community Support

Hi @martin_sperling ,

 

It seems that you do not quite understand what you want, can you provide some screenshot information and describe it so that I can answer it for you as soon as possible.


Looking forward to your reply.


Best Regards,
Henry



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors