How can we improve Power BI?

Lock placement of tables in relationships pane

The ability to 'lock' where tables are manually placed on the relationships pane would be very helpful. We have created a data model with security tables, secured dimensions, unsecured dimensions, and secured fact tables. When I lay out the tables in a specific way, the design is far more understandable than when placement is auto-generated. A 'lock' type of functionality to 'freeze' the table layout would be very helpful because I can more easily locate/verify (a) specific types of tables, (b) bidirectional relationships where they should be (and shouldn't be), and (c) relationship directions are accurate.

197 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

    Melissa Coates 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...
      • Anonymous commented  ·   ·  Flag as inappropriate

        That is good news Amir. At the moment my workaround for this is to take a screenshot of my good layout, print it off and write on the paper(!) - otherwise when it resets I'm lost in a jungle of relationships. I'm getting really desperate for a fix (that sounds all wrong :p)

      • Amir Netz commented  ·   ·  Flag as inappropriate

        OK folks. We hear you and we have work on going to dramatically improve the modeling diagram experience. This will also include making sure that the tables don't move on you by themselves.

      • bullius commented  ·   ·  Flag as inappropriate

        "Under review"?! This is clearly a issue that should be sorted asap, not an idea that could be implemented at some point. It is something wrong with the core functionality of the relationships view. See the link to the issue below that was posted in November 2017. Really annoying.

      • Pat@Energetics commented  ·   ·  Flag as inappropriate

        Just wasted another two hours reformatting the relationship view after addition of a new table triggered an autoformat. Please give us the option to lock this view down. An update on any progress since 1 Feb would be appreciated, as it doesn't appear to be resolved in the March update.

      • David Cresp commented  ·   ·  Flag as inappropriate

        This is a really major bug currently in Power BI and hopefully will get a solution soon. The diagrams resetting themselves is the only something that recently started to occur and is really frustrating. Please MS fix this soon.

      • Peggy commented  ·   ·  Flag as inappropriate

        Very frustrating when you have more than 5 facts and 30 some dimensions...it literally takes me an hour to redo it every time it changes.

      • fabiaN odU commented  ·   ·  Flag as inappropriate

        This is slowly doing my head in, can this be given some attention? I like my dimensions at the top and my fact tables at the bottom and I want that to ALWAYS stay the way i left it. Thank you.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Very frustrating to spend time arranging tables... and to find work undone next time you visit.

      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.