AdminMiguel Llopis (Program Manager, Microsoft Power BI)

My feedback

  1. 22 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

      12 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.

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

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

                66 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  · 
              • 53 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

                  6 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)

                • 78 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  · 
                  • 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

                      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.