Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Triumph
New Member

Power BI Desktop wont import my Power View Sheets

I tried to import my Excel Workbook contents into Power BI Desktop - all my data model tables and queries were imported. However my Power View sheets were not imported instead the "Migration completed" box displays in the power view section - "Power View Sheets (0 items) despite the fact that I have Power view sheets in my excel workbook. Please, can anyone advise on what could be the cause of this issue?

3 REPLIES 3
Sean
Community Champion
Community Champion

I just tested an Excel file - 11 tabs out of 11 total were transfered.

 

Before starting transfer there's a Learn More button/link you may check

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/

 

Some visualizations need to be resized... but overall all looks good

 

Only thing I could see not showing - a Pie Chart with Verticle Multiples - says Visual Not Supported yet but rest on that tab is there

 

And a Satellite background map not showing either...

Sean
Community Champion
Community Champion

Did you maybe mean your Power Pivot Sheets not Power View?

 

It seems all Power View Sheets get imported

 

While Sheets with regular Excel content do not - that incluldes Power Pivot PivotTables / Charts etc...

 

Try creating a simple Power View Sheet and see if it imports...

akjana
Power BI Team
Power BI Team

Which version of Power BI Desktop do you have ? And which version of Excel did you use to create a report ?
Can you create a very simple Power View report and import it successfully ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.