Skip to main content

Power BI

New

Be able to change the data source for live connections

Vote (13) Share
Barry's profile image

Barry on 01 Jun 2016 21:56:44

It would be great if you could use a template that you created while on a live connection and change your connection to another data source so the new data is then populated in the visuals and filters that you have made. This way you could have a base report and be able to apply it to any new data source. Then you won't have to re-create the report every time. Please make this happen!!

Comments (5)
Barry's profile image Profile Picture

c2359ba6 5212-443a-8982-2c46bcaffa25 on 05 Jul 2020 22:59:54

RE: Be able to change the data source for live connections

I discovered this issue when I created a new version of the data source report with a different name, and then discovered that the only way of connecting it was to start a new report from scratch.

It would be great to be able to disconnect the live connection to PowerBI service for a report so the data source can be changed.

Barry's profile image Profile Picture

a2ee0844 df8a-4f42-bdc2-d61ebf3633dc on 05 Jul 2020 22:52:45

RE: Be able to change the data source for live connections

Having to recreate a report because the live data source was moved is a big time sink. I should just be able to relink to a new data source, especially if it's more or less identical to the one that was moved or renamed.

Barry's profile image Profile Picture

a4cad7c1 63c3-479d-b439-189aa3b00e36 on 05 Jul 2020 22:48:00

RE: Be able to change the data source for live connections

We definitely need this facility to change the connection without creating new report. Its an pain to re create all the reports

Barry's profile image Profile Picture

27a2ad6d 5829-45d1-9e72-90b154eebfab on 05 Jul 2020 22:24:28

RE: Be able to change the data source for live connections

Now I have to edit each query that is used in my report and set the source in each one.
The source must be placed in a place that allows to change it by one go for all. This is really a must for portability.

Barry's profile image Profile Picture

302be1b2 a719-4e66-b7f6-a07fbac08e6d on 05 Jul 2020 22:22:42

RE: Be able to change the data source for live connections

And change from import mode to direct query without drawing a new report.