Power Pivot Issue Solutions

One of my current responsabilities is to get people up and running on Power Pivot / Tabular Model connections via SharePoint.

And let me tell you, every machine is different, no two problems similar.

So I'd like to document some of the fixes I've see so far.

1.       Do you have Office 2010 installed?  If not, please load it.

2.       When you open MS Excel, do you see a tab named “Power Pivot”? 
1.       Can also Go to File à Options à Add-Ins à Here you can view if the PowerPivot for Excel is loaded à


3.       If not, we’ll need to download the Power Pivot Add-In from the web.

4.       First we'll need to know if you have Excel 32 bit or 64 bit.
Go to Excel à File à Help à

You can download PowerPivot here:


Choose accordingly.

1.       Choose ENU\x64\PowerPivot_for_Excel_amd64.msi if you have 64-bit

2.       Choose ENU\x86\PowerPivot_for_Excel_x86.msi if you have 32-bit.

3.       Click Download, then run and install.

4.       You may get an error message asking to install .Net Framework  4.0 or Visual Studio 2010 Tools for Office Runtime à http://www.bradleyschacht.com/sql-server-2012-powerpivot-for-excel-prerequisites-error/
5.       If you are not located in the physical United States, you’ll need to modify your computer’s local.
Need to go control panel find à
1.       Once set can change setting back and never have to change it again.
2.       You may also get an error message for .net 4.0:

1.       Will need to install this à http://www.microsoft.com/en-us/download/details.aspx?id=17851

Lastly there are some Analysis Server files that need to get downloaded and installed as well à http://www.microsoft.com/en-us/download/details.aspx?id=29065

1.       Microsoft® SQL Server® 2012 Analysis Management Objects

2.       Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012

Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects.

X86 Package(SQL_AS_AMO.msi)


X64 Package(SQL_AS_AMO.msi)

You may get an error that you need to install Microsoft Silverlight à http://www.microsoft.com/getsilverlight/Get-Started/Install/Default.aspx
And here's some issues troubleshooting Mac --> Power Pivot issues:

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.