Power BI

Needs Votes

Handle data connection updates without forcing recreation of content

Vote (353)

Jayme Edwards on 19 Jan 2016 05:28:11

In the online version of power bi, if you change the account the SSAS connector runs under, the connection in powerbi becomes cached and cannot be updated. Additionally, changing servers from for example one Azure server to another breaks the connection.

For Enterprise customers to use power bi, it is necessary for us to be able to point existing data connections to new configuration locations.

Without this capability, if we move SSAS servers or change the account that the connector runs under, we have to manually create a new connection for all of our users and they must re-create their content that used the old connection!

Comments (14)

Comments (14)

bc807bb2 7c35-4b72-a5e2-2cb1b7110229 on 05 Jul 2020 23:27:37

RE: Handle data connection updates without forcing recreation of content

I master my PBI data model in Excel, mostly because of automation and customizations I have therein. Then I import that model into PowerBI.
Making any changes in the data model (adding a column, creating a hierarchy, etc) requires entirely rebuilding the PowerBI reports & dashboards.

55e90c01 fb03-45e7-a78a-5df3a9bf4fae on 05 Jul 2020 22:23:33

RE: Handle data connection updates without forcing recreation of content

Handle data connection updates without forcing recreation of content

c12edb4a 8769-4116-9274-169adbb9544f on 05 Jul 2020 22:22:20

RE: Handle data connection updates without forcing recreation of content

This is also important when moving from a dashboard test and dev environment to production an enterprise reporting solution change control and testing is required prior to deployment.