Skip to main content

Power BI

Needs Votes

Support switching SSAS connect model from "Connect Live" to "Import"

Vote (566) Share
Jay Eckles's profile image

Jay Eckles on 09 Mar 2017 04:01:59

Once a report is created with an SSAS source using Connect Live, the mode cannot currently be switched to Import. This is frustrating if we have a report that we decide we want to publish to the web.

Comments (49)
Jay Eckles's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:26:15

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This would be a huge time saver. If you have a direct connection report and then need that same report to have the data imported you have to re-create it. Very inefficient!

Jay Eckles's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:10:27

RE: Support switching SSAS connect model from "Connect Live" to "Import"

Should be able to switch between sources in general! Import, connect live, either way. I have a report built using SQL Server Database as the source. Originally was DirectQuery, but changed to Import. Moved the data model into SSAS Tabular. Now I find that I would have to rebuild the entire report?

This is a major issue. At the VERY least please provide some kind of wizard or way to migrate built reports on a data model from one source/method to another.

Jay Eckles's profile image Profile Picture

ManiRaga on 05 Jul 2020 23:06:41

RE: Support switching SSAS connect model from "Connect Live" to "Import"

I have same scenario where we have created Power BI reports using live connection. Now, we want to change live connection to import data with minimal impact to visuals. Please suggest any alternative

Jay Eckles's profile image Profile Picture

Vanessa on 05 Jul 2020 23:06:40

RE: Support switching SSAS connect model from "Connect Live" to "Import"

this is very annoying, i understand imported to live, but from live to imported, how hard can it be?

Jay Eckles's profile image Profile Picture

CAHUEP on 05 Jul 2020 23:03:57

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This is a frustrating, please make it possible that we can switch between Live Connection and Import

Jay Eckles's profile image Profile Picture

Power BI User on 05 Jul 2020 22:58:15

RE: Support switching SSAS connect model from "Connect Live" to "Import"

Must be an option to change from live connection to import.

Jay Eckles's profile image Profile Picture

Anonymous on 05 Jul 2020 22:57:49

RE: Support switching SSAS connect model from "Connect Live" to "Import"

Absolutely necessary!
Can not understand why this is not already in.

Jay Eckles's profile image Profile Picture

Power BI User on 05 Jul 2020 22:56:59

RE: Support switching SSAS connect model from "Connect Live" to "Import"

yes the functionality should be available

Jay Eckles's profile image Profile Picture

TePe on 05 Jul 2020 22:56:49

RE: Support switching SSAS connect model from "Connect Live" to "Import"

Also if you want to add another data source to a "Connect Live" report you currently need to rebuild the report. There should be a "transform" from "Connect Live" to "Import" to make it easy to create data mash-ups.