Forum Discussion
Change data source in Power BI service
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.
Yes lbendlin abpgupta , I finally managed to solve the problem
1. I couldn't edit the parameter fields on the PowerBI Service side to put the prod url, so I had to do this : change Type Parameter to "Text" in Power Query
2. Once published, I still had the data from the dev database even though I'd modified the source, but I had to do this trick : reload the semantic
Everything's working fine now, but you may have some suggestions for improvement.
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.