Change the environment from Sandbox to Production

[ankush-vem]

Hi Team, 
I've recently created a few reports in PowerBI while being connected to the Sandbox Environment (Dynamics 365 Business Central). I'd like to know if there's a way where I could just change the data source from Sandbox to Production environment.

Thanks

[amitchandak]

@ankush-vem , Yes, You should able to change the connection to production and use.

Another way is the deployment pipeline

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview

Abstract Thesis:How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY