Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using Parameters with Dataflows

Currently, I get data from postgresql.  I connect to data from two different databases, test and production.  My current process is to create on report.  Within that report, I have a parameter that specifies the database I want to connect to.  I set the parameter to production, load the data and publish to my production workspace.  I change the parameter to test, load the data and publish to my test workspace. 

I am now trying to utilize dataflows and wondering if there is way to do this and still achieve what I am currently doing with the parameters.  I can create two dataflows with identical structures - one with test data and one with production, but I don't see how to toggle between these in Power BI Desktop like I do with the parameters.  I also see that you can create parameters in the dataflow like I do in Desktop, but I don't see at all how this is useful.  

Any help is appreciated.

5 Replies