Forum Discussion
How to switch between Development and Production servers when using Enterprise Gateways?
Hi BBIUser,
After testing is completed in Power BI Service workspace, how do I change the connections to production data/server???
Do I have to go back to Power BI Desktop (Data source settings) and change/point it to production server and then re-publish the report again?
Or
Is there a way for me to switch to production data/server in Power BI Service?
In Power BI Service, the only thing I see is the Gateway Name (under Datasets settings) and nothing that shows developement or production data source name to switch between them.
For your requirement, I found this blog Using the Power BI Service Parameters to change connection strings could help you.
Best Regards,
Cherry
- BBIUser7 years agoHelper IV
Anonymous Thanks for sharing the link, I still din't try what you shared as Cherry's solution was closer to what I was trying to achieve.
v-piga-msft Cherry, Thanks for sharing the blog!
I was able to partially reproduce what was given in the blog. I am missing something here to get the actual results.
Let me give my scenario:
- I have just 1 dataset in Power BI Desktop. I want to use this same dataset to create reports and switch from development to production.
- Used Import connection.
- No SQL Statement since I am connecting to just 1 table directly.
- I have created 1 parameter for Server Name where the 'Current Value' is having Development Server information.
- I have created 1 parameter for Database Name which should be the same for production.
1) Should I create another Parameter with Production Server information?
2) Even if I publish with 2 parameters (Dev and Prod), all I can see only the parameter which was selected, saved and published through Power BI Desktop.
I cannot change the Parameter in Power BI Service.
3) Where should I declare the @@ServerName, since I am not using the SQL Statement instead have imported the table?
Thanks again!
- Morty7 years agoRegular Visitor
You need to select a type for your parameter other than any. The parameters remain greyed out if Any is selected. Try a type of Text.
- HarleenKaurD2 years agoMicrosoft Employee
Just type a connection String either Dev, Stg, Prod and it will start populating as shown. Hope this helps.