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.
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.
Solved! Go to Solution.
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?
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.
@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/
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.