dev to prod

[power_user_123]

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.

[Kishore_Kadhir · Accepted solution]

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 · Accepted solution]

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

[Kishore_Kadhir · Accepted solution]

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