Forum Discussion
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 report(s) are import mode. We need this support ASAP!
5 Replies
v-ljerr-msftMicrosoft Employee
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
Try this one- https://msdn.microsoft.com/en-us/library/mt814715.aspx
It's newer and supports import mode for few datasources.
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"
}
}
}
