How dynamically change the environment from testing to production

[spathak04]

Hello,
I have a power Bi desktop and report server version. I get the data from SQL server stored procedures.
My requirement is when I create or test any report it should use my testing environemnt and once I deploy to production it should connect to production environment .
Both of my develpment and production servers are different. I have a reporting server too. 

[v-shex-msft · Accepted solution]

Hi @spathak04,

In my opinion, I'd like to suggest you to parameterize your query tables with query parameters, then you can simply switch data source between test and production environment on power bi service side.

There are some reference links about blog and document below, please take a look on it to know more steps:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

What is a query parameter?

Regards,

Xiaoxin Sheng

[spathak04]

Thank you somuch. I think this article could help me a lot.