Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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!
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