Forum Discussion
Dynamically Change Workspace Id/Name When Pulling Data Flow
Not sure if this is resolved, or if my response will help. But I have created a template pbix file on my GitHub account:
https://github.com/JamesCameronMathews/PowerBI_Stuff/blob/main/PBI_Dataflow_Template.pbix
This approach allows parametric management of the selected datasource.
-Paramaters (query group):
-- workspaceName (parameter): Parameter controlling the workspace containing the target dataflow
-- dataflowName (parameter): Parameter controlling the target dataflow
-- Workspace (list): List of available workspaces (auto-populated)
-- Dataflow_Name (list): List of available dataflows (auto-populated)
-- DataflowSelector (table): Table with the id for the target workspace and dataflow, dependant on parameters selected
- YourTable (Table): Example query showing how to use target a table in your dataflow using your above