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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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

MattAllington
Community Champion
Community Champion

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.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.