Using Parameters with Dataflows

[schwinnen]

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.

[Greg_Deckler · Accepted solution]

Have you looked at this?
https://powerpivotpro.com/2019/04/power-query-magic-parameters-for-dataflows/

[MichielvS]

Would you happen to know if there is a way to parameterize the frase "Source = PowerPlatform.Dataflows(null)," in Power Query for Power BI Desktop?

[schwinnen]

I did now.  It is pretty confusing in my opinion.  Prior to posting my question, I did a quick internet search and didn't see much.  But maybe I'll dig a little deeper and see if there's someone who explains the process a little better.

[schwinnen]

@Greg_Deckler - I think the link below has a better solution.   This was a link included in the article you sent me to.  So, in a way, your solution worked for me.  

https://data-marc.com/2019/04/16/pimp-the-dataflows-connector-in-power-bi/

[Greg_Deckler]

A bit round-about but glad you got it! I will have to take a look at your link and see what they did! Thanks for sharing! 🙂