Integrate Powerbi with Pivot tables

[Sanjay5]

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.

[philip_meier]

Are there still no pivot tables?

[KathyPullin]

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/

[tmartens]

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.

[pbiideas1]

Without PivotTable,power bi is nothing.

[krishnatheja231]

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

[fran_mcloughlin]

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.