Forum Discussion

trevorgermain's avatar
trevorgermain
Icon for Advocate I rankAdvocate I
8 years ago

No SetAllConnections support for ImportMode a show stopper!

As an enterprise SAAS organization, we need to automate all of our deployment processes. I've got a full deployment scenario scripted, but it fails on SetAllConnections due to the fact that the repor...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi trevorgermain,

 

For anyone who also need this feature, please vote the idea and add your comments here to improve Power BI on this feature. :smileyhappy:

 

Regards

    • trevorgermain's avatar
      trevorgermain
      Icon for Advocate I rankAdvocate I
      8 years ago

      The request allows you to change server and database. How do you also update the credentials for the source? Obviously, if you are changing to a different environment (e.g. staging to production), there will be a different set of credentials.

      {
            "connectionDetails":
            {
              "server": "new-Sql-Server.com",
              "database": "new-Sql-Database"
            },
            "datasourceSelector":
            {        
              "datasourceType": "Sql",
              "connectionDetails": 
              {
                "server":"My-Sql-Server",
                "database":"My-Sql-Database"
              }
            }
          }