Forum Discussion
How to switch between Development and Production servers when using Enterprise Gateways?
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!
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.