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,
We have different workspaces using them as different environment.
We have datasets in DEV_DS workspace for DEV and dataflows in DEV_DF workspace that have dataflows(say DF1,DF2,DF3).
dataflows are used as source for datasets.
same way I have UAT_DS, and UAT_DF worspaces,
when I deploy any dataset from DEV_DS to UAT_DS, that should now point to DF1,DF2, DF3 in UAT_DF workspace.
Just wondering how we can do it with minimum manual work.
we are open for solution using PoweShell or Python Script.
Note: I am not asking how to deploy dataflows or Datasets, my concern is repointing dataset's tables to dataflows in UAT workspace.
Thanks
You can create parameters in the Query Editor for this, say one called "environment" you would set to DEV or UAT, and use that parameter in your queries' data source strings. Then that parameter can be set from the dataset settings of a published dataset.
If using Premium, you can set these automatically with Deployment Pipelines.
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.