Forum Discussion
Solved
Change data source in Power BI service
Hello, I'm new to Power Bi service, so I'm having trouble doing some things (maybe not possible at the moment). I have several Postgresql data sources, I have access to one (the dev one) locally ...
Yes, Parameters is the right approach. Did you use these parameters in your original connector?
In Power Query, you can define Parameter and input all databases name as input. All other queries should be changed to use this parameter to refer for Data source name/connection strings. Once published to Service, it will be available to set on Semantic Model's settings.
For string inputs, always use Text as type of data and avoid using "any". You can also create list of values as table and use as input in parameter to have control on string values.
I've seen this option in Power BI Desktop and I've added the two urls, but Power BI Service doesn't suggest the selection. I still have to enter the url and database name.