Forum Discussion

power_user_123's avatar
power_user_123
Frequent Visitor
4 years ago
Solved

dev to prod

Hi !
I created few reports in Power bi desktop. The data source is Azure databricks (dev enviroment). Now, how do I change the datasource to Prod environment for existing reports. I tried to create parameter for the datasource but could see that option for SQL server. But couldn't see the drop down option for creating parameter for the databricks connection. So, What is the best way to change the environment for already created reports from dev to prod with minimal efforts.

Thanks.

Need Help
  • Kishore_Kadhir's avatar
    Kishore_Kadhir
    4 years ago

    Hi,

     

    You can create a parameter with dev and prod server paths. Then go to advanced editor and replace your dev server with this parameter and leave the default value as dev. Change it to prod after publishing. Hope it helps.

     

    Regards,

    Kishore

  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi power_user_123 ,


    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

    Best Regards
    Lucien

2 Replies

  • Kishore_Kadhir's avatar
    Kishore_Kadhir
    Resolver II
    4 years ago

    Hi,

     

    You can create a parameter with dev and prod server paths. Then go to advanced editor and replace your dev server with this parameter and leave the default value as dev. Change it to prod after publishing. Hope it helps.

     

    Regards,

    Kishore

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    Hi power_user_123 ,


    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

    Best Regards
    Lucien