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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.

Top Solution Authors
Top Kudoed Authors