cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors