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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors