Import Excel Pivot to PowerBI - Possible???

ovetteabejuela  If you've already setup your the Data Model in Excel you can Import it

in PBI Desktop => File => Import => Excel Workbook Contents

This will actually bring in your Data Model Tables AND your PowerView Sheets ONLY

Note that None of your "regular" Excel Sheets which includes the Sheets containing PivotTables will be imported!

Therefore if you don't have any PowerView Sheets you'll just see a blank page in the Report View after you've imported

the Workbook Contents into PBI - however your data tables should be seen on the right side in PBI.

Also if you switch over to the Data View or Relationship View you will see the Data Model Tables that were imported!

If you do have PowerView Sheets that Import successfully note that there are some limitations as not all Visuals are avaible in PBI

One of the most glaring omissions - charts with Vertical or Horizontal Multiples will not be displayed

Please Vote here (Note this Idea is supported by Rob Collie)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9750957-vertical-and-horizontal-multiples-small-multiples

Also PowerView Maps with satellite background will not display either

Please Vote here

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9583053-aerial-satellite-photo-ma...

During the Import Process you'll be shown what's imported as in the picture...

Also I'll just mention that if you are starting to build your Data Model and Excel is just your Data Source

PBI Home tab => click Get Data => select Excel => choose your file

However you asked about Importing a Pivot Table and unfortunately that is not possible!

Hope this helps! :smileyhappy:

Documentation:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/#which-workbook-elements-are-imported