How can we improve Power BI?

Integrate Powerbi with Pivot tables

Hi, I have used Powerview extensively. Pivot table connected to a Tabular Model is today the best available tool for pivoting. Nothing to beat it. howevere powerview and pivot tables are not integrated to each other, i.e. they do not share the same parameters. The filters I have selected in Powerview shold also filter (optionally) a pivot table also.

576 votes
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)

    We’ll send you updates on this idea

    Sanjay Shah, Pune, IndiaSanjay Shah, Pune, India shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    76 comments

    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)
      Submitting...
      • Fran McLoughlinFran McLoughlin commented  ·   ·  Flag as inappropriate

        I cannot believe that Power BI has not integrated Power Pivot into its matrix.
        All of the current report offerings are no more than eye-candy to me.
        I "migrated" to Power Bi as I thought it might be an upgrade to Power Bi.
        While the memory management issue seems to be under control the report offerings are of no real interest.
        I for one would be glad to put my money where my mouth is to push Power Bi up the development list.
        "Printing is only available in Power BI service and not Power BI Desktop" - why...
        "Reports can only be printed one page at a time -- you can't print the entire report at once." - why...
        My clients have a tough enough time accepting BI as its user paradigm is so different from the rest of the MS Suite.

      • Krishna kishoreKrishna kishore commented  ·   ·  Flag as inappropriate

        Kindly integrate pivot tables in power bi... because of these few things which are missing in power bi, we are forced to look at other tools like tableau and spotfire. power bi has got a great potential... but at the same time it is not complete...

      • KathypullinKathypullin commented  ·   ·  Flag as inappropriate

        I can see Pivot Tables in the Power BI sample file Titled "Customer Profitability Sample". When I click on the table, it shows "Pivot Table Fields". I can alter the table, update it, click on fields to include or remove from the pivot. Isn't this an integration of Power BI with Pivot tables? The sample can be downloaded from here: https://powerbi.microsoft.com/en-us/documentation/powerbi-sample-customer-profitability-take-a-tour/

      • TomMartensTomMartens commented  ·   ·  Flag as inappropriate

        There is no solution in Power BI that is near to the capabilities of the Excel Pivot Table to use ragged hierarchies or to be more specific use Parent/Child dimensions from a Analysis Services Multidimensional Model. Some of my SSAS MD models build eons ago, make use of ragged hierarchies and Parent/Child dimensions. Currently customers that have to rely on these hierarchies, types of dimensions to get some of their analytical questions answered are more than hesitant to give Power BI a chance. And we all know Power BI deserves better.

      • Dewayne DelkDewayne Delk commented  ·   ·  Flag as inappropriate

        The lack of pivot charts alongside pivot tables is a show-stopper for recommending Power BI to our analysts. This kit is designed to be used for information discovery so it should be able to flip and spin data views even better than Excel. I see each month things being added and they are of little use if we aren't using the software because it lacks the basics

      • Anonymous commented  ·   ·  Flag as inappropriate

        Yes, we need this too. Why was pivot table removed in access 2013? Why not include it in power bi? It was such a good control...

      • Anonymous commented  ·   ·  Flag as inappropriate

        Will, to answer your question: "What is it about Pivot Tables that are useful?" It's the summary of values at various levels of a hierarchy and being able to drill in, dynamically to different levels of that hierarchy. Particularly, ragged hierarchies. Pivot tables handle that view much better than Matrix or table visuals.

      • Nandor SantaNandor Santa commented  ·   ·  Flag as inappropriate

        I realy like to see the numbers too, a pivot table gives the possibility to colaps columns, and to filter the data when I click on dat from a cretin column.
        I used this functionality a lot in QlickView, an even nicer pivot table was introduced with QlikSense.
        A pivot table tile in the dashboard would be just extraordinary.

      • rgoerwitrgoerwit commented  ·   ·  Flag as inappropriate

        There are several things going on here:

        1) Power BI tables are limited and restricted (other visuals are generally much better); Excel is much better at this sort of thing, and so I'd really like to be able to hook an Excel pivot table to a Power BI model, so I can get the best of both worlds - but also get the latest DAX/xVelocity (why in heaven's name Excel and Poser Bi run different versions of this, I dunno, but if that's how it's being done, then I want a way to tie Excel to the models I create in PowerBI)

        2) I'd like to be able to create a model in Power BI then download the model offline for use with Excel in situations where I have no access to the cloud, or to the network generally (e.g., in places where security is an issue, on an airplane, etc.)

      • Ryan RRyan R commented  ·   ·  Flag as inappropriate

        What's important in the pivot table. Being able to:

        1) Expand and collapse rows and columns to see summaries and details underneath
        2) Being able to double click on the data cell and see the data (or single click and show a pop-up table would be even better)
        3) Being able to filter the data in the pivot table based on the data tables field contents
        4) Being able to sort the data so see
        5) Being able to see add data bars and color scale (excel terminology) to visualize how the data compares to others ones in the column/row

      • Chirag AgarwalChirag Agarwal commented  ·   ·  Flag as inappropriate

        I had voted for this long back and dont really remember when I did so. If I look at this again today, I can do this using the Matrix visualization available in PowerBI Desktop. thanks! removing my votes for this..

      • AlisonAlison commented  ·   ·  Flag as inappropriate

        PLEASE VOTE for this one and the one noted below if you have enough votes.
        This is related to another issue that currently have almost the same amount of votes: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-values-on-rows-instead-of-colum

        These are several "ideas" posted for this feature set (all couched a little differently but essentially the same). The Matrix visual is helpful but does not have enough features to make it very useful, especially when looking at data over time (YoY, month to month, the fiscal year for P&L, just to name a few. Even adding some of the more basic parts of 'pivot table' functionality would greatly enhance this and fulfill a need that many are requesting.

        This is a huge gap right now. Please tackle this one.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We were searching for a Pivot table chart and it is surprising that power BI does not have that. We are rebuilding reports that have already been built using Oracle VA and SAP VA. The pivot is available in these others. Why power bi does not have them yet.

      • Randy VoltersRandy Volters commented  ·   ·  Flag as inappropriate

        Pivot tables in reports are often called cross tab reports. Not everything in BI can be 'visualized'. Sometimes a summary of data is required by executives and cross tab (pivot) tables are needed. Another way to say it is this - Without a native pivot table ability in the Power BI Desktop, it will not be as successful as it otherwise could be. Waving at Excel and speaking of importing a pivot table from Excel into Power BI is just not a solution. Put a Pivot table capability in the Power BI deliverables and you'll get more interest.

      • rgoerwitrgoerwit commented  ·   ·  Flag as inappropriate

        Pivot tables in Excel against an OLAP source work great: They can be formatted various ways, with lines, colors, conditional formatting, and so on. The Power BI table is very limited and hard to read. It would be great if we had at least a little more control over how data gets displayed in a Power BI table.

        I don't advocate, however, building it out to the point where it works like Excel. Rather, we should simply be provided with a way to drill across to an SSRS report, or to Excel Online.

      • Jordan FoxJordan Fox commented  ·   ·  Flag as inappropriate

        Absolutely need pivot tables to drive a P&L like report, supported by the visual dashboards. It's a requirement, financial people like to look at numbers and currently the matrix doesn't fit the bill. We need pivot table like support.

      ← Previous 1 3 4

      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.