Skip to main content

Power BI

Needs Votes

Be able to change the data source for live connections

Vote (14) 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

Daniel 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

Nick Gouwens 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

Nagaraja Char 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

Power BI User 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

Power BI User 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.