Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (556) 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 (51)
    Jay Eckles's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:28:13

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

    And also from import to connect live. Another matter is that i can't believe that when importing data PBI can't maintain the structures and joins all the attributes in one structure called model or something like that.

    Jay Eckles's profile image Profile Picture

    Rudolf Limburg on 05 Jul 2020 23:26:37

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

    Great addition and would be very useful too the other way around (change an imported connection to a live connection)

    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