Skip to main content

    Power BI

    Needs Votes

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

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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    55d2d609 f75b-48a2-b45b-00373946958f 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    a92640e2 9aa9-4bbe-ac79-fd46e98c9402 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

    491e88b8 ec3d-4561-afb3-34890608fc7f 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

    ac92e62c 159d-4f73-a316-24b7039f780a 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

    604336ed 27eb-4e69-90b8-125bc3099b39 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

    d8df3dc5 0fbe-4b20-b448-945e77cffeb2 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

    f02ad612 53dc-4404-beeb-82e2ca084c34 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

    10bd10ae 4054-4144-b88b-5b9f80e0ed9c on 05 Jul 2020 22:56:59

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

    yes the functionality should be available