Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Toggle between Azure SQL database connections belonging to different environments

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?

Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    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.

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    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.

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

    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.