Forum Discussion

martin_sperling's avatar
martin_sperling
Advocate I
3 years ago

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. 

Need Help

2 Replies

  • martin_sperling's avatar
    martin_sperling
    Advocate I
    3 years ago

    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's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    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