AdminMiguel Llopis (Program Manager, Microsoft Power BI)

My feedback

  1. 1,070 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

      @Zachary - That is currently possible when using Import mode for SSAS, not with Live Mode. This scenario does not cover expanding capabilities for Live SSAS mode, but rather it ensures that the scenarios that are already possible in Power BI Desktop today work via the Gateway for refresh purposes.

    • 9 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

        7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →

        Thanks for your feedback - note that, as a mitigation for this issue, you can enable Hierarchical Navigation from the connector dialog (i.e. From Oracle), which will group the navigator tables by schema. Generally, you won't have 10,000+ items within a single schema.

      • 3 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

          1 comment  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →

          Thanks for the feedback - Note that this can be done today based on M formula tweaks. There's a Table.ColumnNames function that you can use on any table and will return a list of column names (sorted by "natural order"). So, to reference "the second column of a table" you could use Table.ColumnNames(yourTable){1}

          For example, this formula removes the second column of the table: = Table.RemoveColumns(yourTable,{Table.ColumnNames(yourTable){1}})

        • 2 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

            1 comment  ·  Power BI Ideas » Support  ·  Flag idea as inappropriate…  ·  Admin →
          • 1 vote
            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

              1 comment  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →

              Thanks for the suggestion - Note that you could achieve this today by adding a custom column with the Query Name (i.e. "Query 1") to each query, before performing the Append operation.

            • 135 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

                8 comments  ·  Power BI Ideas » Custom Connectors  ·  Flag idea as inappropriate…  ·  Admin →
                AdminMiguel Llopis (Program Manager, Microsoft Power BI) supported this idea  · 
              • 659 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

                  51 comments  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →

                  We’re actively working on adding IntelliSense support for M authoring in the Advanced Query Editor, Formula Bar and Custom Column dialog. Expect to see these capabilities in one of our next few monthly updates, hopefully before the end of 2016. : )

                  AdminMiguel Llopis (Program Manager, Microsoft Power BI) supported this idea  · 
                • 42 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

                    3 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →

                    This should also include the ability to sort by multiple columns (just like in Excel)

                  • 76 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

                      8 comments  ·  Power BI Ideas » Q&A  ·  Flag idea as inappropriate…  ·  Admin →
                      planned  ·  Nick Caldwell responded

                      Now that we feel the UX is solid, we are moving this one to planning phase.

                      AdminMiguel Llopis (Program Manager, Microsoft Power BI) supported this idea  · 
                    • 8 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

                        3 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →

                        Thanks for the feedback, Jared. This is something that we're tracking and expect to improve in a few months.

                        In the meantime, there is a workaround for you which is to create a Blank Query and "type = #shared" in the formula bar. This will list out all available functions and types as a list of records. If you then use "Into Table" in the ribbon, you will be able to use Filter, Sort, etc. as a way of searching for what you want.

                        Not the most usable approach, but will get you a long way until we get the real feature in the product. :)

                      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.