Toggle between Azure SQL database connections belonging to different environments

[Anonymous]

How do I allow toggling between Azure SQL database connections belonging to different environments.

My report in dev workspace needs to connect to Azure SQL dev Database and in prod workspace should connect to Azure SQL prod database. When I check the Dataset setting in Dev the database name is disabled though I have parameterized the database name before publishing the report. What am I doing wrong?

[v-chenwuz-msft]

Hi @Anonymous ,

Please set the parameters Tyep to Text

And republish it again.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi @Anonymous 

Can you ensure that your datatype is not set to ANY, if it is then it will not allow the parameters to be used.