Moving Shared Datasets / dataflows through environments (QA->UAT->Prod)

[jack_kennedy]

Hi,

Thanks in advance for any help with this one!

I currently have 25 Dataflows (Blank Query) which are pulling data from our source system Oracle DB in QA. There is a Shared Dataset that is servicing all of my reports that uses these Dataflows as its Data Source.

Now I need to move my Shared Dataset to UAT and then to Prod. Meaning the 25 dataflows I have set up need to pull data from 2 new environments. I dont want to have to recreate the 25 Dataflows for UAT (pointing to the UAT Source DB) and then set them up again for Production.

I would like to copy my existing Shared Dataset to UAT and then have this dataset pass down the hostame credentials to the existing 25 Dataflows to pull data from UAT - therefore I still have the same Dataflows set up but they will just pull from a different environment depending on which Shared Dataset is calling them.

Is this possiblle? I have been able to set up a parameter called SourceDB in each Data flow where I can see tthe hostame of the source system. But I'm not sure how I can pass this down from the outside.

Any help greatly appreciated

Cheers,

Jack

[TomMartens]

Hey @jack_kennedy ,

according to this: https://powerbi.microsoft.com/en-us/blog/50-new-features-in-dataflows-this-month/

Parameters used in dataflows can be currently accessed by using the query pane only.

Regards,

Tom