How can we improve Power BI?

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

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.

155 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jay Eckles shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    12 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • lrmmf commented  ·   ·  Flag as inappropriate

        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.

      • Rudolf Limburg commented  ·   ·  Flag as inappropriate

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

      • Anonymous commented  ·   ·  Flag as inappropriate

        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!

      • Anonymous commented  ·   ·  Flag as inappropriate

        This would be a useful feature that would allow us to not have to recreate reports

      • Joel Faltermeier commented  ·   ·  Flag as inappropriate

        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.

      • ManiRaga commented  ·   ·  Flag as inappropriate

        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

      • Vanessa commented  ·   ·  Flag as inappropriate

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

      • CAHUEP commented  ·   ·  Flag as inappropriate

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

      • TePe commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.