cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trevorgermain Regular Visitor
Regular Visitor

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 5
v-ljerr-msft Super Contributor
Super Contributor

Re: No SetAllConnections support for ImportMode a show stopper!

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. Smiley Happy

 

Regards

Power BI Team nimrod
Power BI Team

Re: No SetAllConnections support for ImportMode a show stopper!

Try this one- https://msdn.microsoft.com/en-us/library/mt814715.aspx

It's newer and supports import mode for few datasources.

trevorgermain Regular Visitor
Regular Visitor

Re: No SetAllConnections support for ImportMode a show stopper!

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"
        }
      }
    }

Power BI Team nimrod
Power BI Team

Re: No SetAllConnections support for ImportMode a show stopper!

trevorgermain Regular Visitor
Regular Visitor

Re: No SetAllConnections support for ImportMode a show stopper!

What was nice about SetAllConnections was that I could set all connections to a specific connection string. My scenario:

- I develop a report, connecting to a local copy of a database. (e.g. instance = server1, db = DataWarehouse

- My teammate develops a different report, connecting to a local copy of his database. (e.g. server2, db = DW

 

With SetAllConnections, I can write a deployment that imports both reports from source control, and updates both reports to connect to production (e.g. instance = azureserver\production db = DataWarehouse).

 

With UpdateDatasource, I need to explicitly know that the "source" database to update is server1; DataWarehouse and server2; DW. This removes the ability to have a generic deployment script.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 212 members 2,279 guests
Please welcome our newest community members: