Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.