BI in SQL vNext

What should we add to the BI capabilities in the next version of the SQL boxed product

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Power Query: stop adding "Change Type" steps automatically

    Please prevent Power Query from automatically adding "Change Type" steps after loading data from table or splitting a column. Many times it considers the whole column as numeric even when you have text in some cells. I get errors because of this all the time and have to keep removing these automatically added steps.

    6 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
    • A strong input forms that link messages, skype and yammer to analytics

      Create real analyze into action with medsage tracking related to visualisation

      7 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • power query

        Enable power query for tabular model design but most importantly enable power query refresh when importing from Excel PowerPivot

        15 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
        • Conditional format

          Add conditional formatting to the matrix like excel has.

          28 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Power View  ·  Flag idea as inappropriate…  ·  Admin →
          • STOP! Before throwing more random features into SQL BI, lay out strategic guidance

            Reporting Services, Analysis Services, PowerPivot, PowerView, PerformancePoint, Report Builder, Excel Services, Analytic Charts, Datazen... Microsoft's BI toolkit is a mess. Anyone who's starting out fresh could go insane trying to figure out what to use when. Add in Microsoft's tendency to randomly abandon technology and something packaged and stable like Microstrategy or Tableau starts to look like it's worth the money.

            You folks need to put your pencils down, step back, take a deep breath, and FIGURE OUT WHAT THE HECK YOU'RE DOING. Lay out an architecture, roles, and roadmap that can be published for all of us so we…

            118 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              7 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
            • Combine Datazen, PerformancePoint, PowerPivot, SSRS, and SSAS into one nice packaged product which can be deployed to Cloud & On-Premise

              Combine Datazen, PerformancePoint, PowerPivot, SSRS, and SSAS into one nice packaged product which can be deployed to Cloud or On-Premise where data security is a concern

              188 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                7 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Exporting existing SP13 Power View Dashboard into Power BI Desktop

                The august release of Power BI Desktop added the capacity to import Power View Dashboard created in Excel, into Power BI Desktop but... what about those Dashboards we have created with Power View for SP13? At least, capacity to import *.RDLX files to Power BI and avoid recreate them all!

                6 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Power View  ·  Flag idea as inappropriate…  ·  Admin →
                • instead data getting from table and function incude stored procedure returning data also.

                  instead data getting data from table and function include stored procedure returning data also

                  31 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                  • PowerBI desktop to replace Report Builder

                    Then the SSRS platform could be explored as an on-premise PowerBI.com

                    24 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • customizable auto lables

                      add a dictionary config file who able we to replace auto labels - like total - with our labels.
                      thanks

                      21 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Power View  ·  Flag idea as inappropriate…  ·  Admin →
                      • More Statistical Functions inline with Excel like NORMSINV AND TINV

                        add more of the Excel Statisical function so we can actually start doing some real statistical analysis and normalization of data

                        30 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          2 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
                        • SSIS - FIX THE UX! Resizing and objects flying off the page

                          Attempting to resize an object or reposition a object is almost impossible. It's not possible to drag or resize an object up or left; the ui changes the cursor to a (\). It's the opposite for down and right; the object flies 100000000s of pixels in an instant. You then have a design pane that needs to be zoomed out to 0.1% to see everything on one screen.

                          This makes arranging packages that go beyond a single data flow that has source->destination very tedious.

                          There's many threads on connect and the msdn forums about this when this bug appeared in…

                          18 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                          • 70 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • add synonym feature

                              Add Synonym feature to BIdesktop for better Q&A of data - as in powerpivot in Excel

                              39 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Web API Connector

                                Add a connector to Web API to accelerate the consumption of the HTTP Request.

                                10 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                                • An adhoc cube browser tool

                                  While all the PowerView dashboarding capabilities are very nice and highly used, majority of our customers are analysts who'd like to be able to browse through a cube to perform ad-hoc analysis. A need for an ad-hoc cube browser tool is very strongly felt in such cases. A parallel would be tools like ProClarity (while it was still available),Cognos Analysis Studio and even SQL Management Studio! We can't deploy Management Studio across all work machines for Business Analysts and no, Excel is not the best cube browser out there. Please provide a finer version of an ad-hoc cube browser so…

                                  27 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  SSAS OLAP  ·  Flag idea as inappropriate…  ·  Admin →
                                  • The more you can integrate Datazen into the final build the better.

                                    Datazen is awesome. Please integrate it as much as possible into the final build.

                                    51 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      2 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 38 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                                      • aggregate

                                        Aggregate Awareness (Aggregate navigation) is needed. As relational or tabular mode is a strategic way to do warehousing, Aggregate Navigator is important feature, as Kimball point, and implemented in SAP BO, Microstratedy and Cognos BI Power Cubes.

                                        5 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Power Query M script - simplify line labels

                                          Power Query's M Script is unnecessarily wordy and hard to reuse, as each line must include a reference to the previous line's label. A solution could be a generic tag e.g. "PreviousStep" which would always point to ... (drumroll) ... the Previous Step.

                                          This would simplify M Script and make it more readable. Reuse of code would be much simpler as rows of M Script could be copied and pasted at will, without needing to carefully tend to previous line labels.

                                          11 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          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.