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
nzcncf
New Member

How to view the original data in "Retail Analysis Sample.xlsx"?

Hi,

 

I've downloaded the sample spreadsheet, and would like to view the actual data. However, when opened in Excel 2010, only the Power View is visible. Anyone know how to view the original data?

 

Thansk.

3 REPLIES 3
v-sihou-msft
Employee
Employee

@nzcncf

 

You need to install and start "Power Pivot for Excel".

 

Capture23232.PNG

 

Then you can click Manage to see the underlying data in PowerPivot model.

 

Capture999.PNG

 

Capture77.PNG

 

Regards,

can I just say it's ridiculous to have the sample data using a plugin that isn;t available in all versions of excel.  For learning purposes this file is utterly useless to me, clearly my company don't spend enough wtih you every year...  

Do you have power pivot installed?  You need the plugin. Also the workbook must be Excel 2010 power pivot to view it in 2010 - there is no backward conversion from 2013



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.

Top Solution Authors
Top Kudoed Authors