Internals « PowerPivot Twins!

Archive for the 'Internals' Category

Cannot add the specified assembly to the global assembly cache

Published February 14, 2010 Internals , Uncategorized Leave a Comment
Tags: SharePoint, Troubleshooting

By Lee Graber (leegr@microsoft.com), on February 12th, 2010

This is part of my continuing series on debugging SharePoint and PowerPivot. In this case, I do not expect any PowerPivot users to ever encounter this error in the context of PowerPivot. However, the general SharePoint developer who is in the early stages of building and testing his custom solutions might hit this and since so many people on our team have been confused by it, I thought I would throw out some help for other developers. This error is hit when trying to deploy a SharePoint solution package to the farm. It could be an ApplicationServer solution or a WebFrontEnd solution, the important part is that it has an assembly marked to be deployed to the GAC:

The data connection uses Windows Authentication and user credentials could not be delegated

Published February 14, 2010 Internals Leave a Comment
Tags: Geneva, SharePoint, Troubleshooting

By Lee Graber (leegr@microsoft.com), on February 8th, 2010

This is one of the two main errors that users could see from Excel Services when using PowerPivot. This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of understanding of what Excel Services is doing is required. For this, I recommend reading an earlier post on this blog by Dave … http://powerpivotgeek.com/2009/12/11/excel-services-delegation/. In general, this is an add-on to Dave’s post which is a quick summary of how to debug this error.

Dashboard Bubble Chart Shows a Red X (fails to load)

Published February 14, 2010 Internals Leave a Comment
Tags: Management Dashboard, Troubleshooting

By Lee Graber (leegr@microsoft.com), on February 8th, 2010

If there is any error trying to load the bubble chart data for the dashboard, instead of getting a page load failure, the bubble chart simply displays a red X. Whenever you get a red X in the bubble chart there will be an associated log entry in the ULS log on the machine running the Central Admin site. It will look something like this:

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook

Published February 14, 2010 Internals Leave a Comment
Tags: Data Refresh, Troubleshooting

By Lee Graber (leegr@microsoft.com), on February 7th, 2010

This error is another in a series of common errors that users can hit during seemingly normal scenarios that might be a little bit difficult to interpret at first. We actually did work to try and make the error descriptive, but to the new user, it may still be cryptic. This error occurs when you chose the “Manage PowerPivot Data Refresh” option of an xlsx file which does not contain any embedded PowerPivot data.

Weird timer jobs

Published February 14, 2010 Internals Leave a Comment
Tags: Timer

By powerpivotgeek (dwickert@microsoft.com), on February 6th, 2010

Sometimes when you look at the timer jobs associated with the PowerPivot service application you see these weird entries:

So where do they come from and what do they do?

Memory Considerations in PowerPivot

Published February 14, 2010 Internals , Perspectives Leave a Comment
Tags: memory

By powerpivotgeek (dwickert@microsoft.com), on February 3rd, 2010

In scanning through some recent discussions on the PowerPivot forums, I noticed this very nice posting by Marco Russo (http://sqlblog.com/blogs/marco_russo/archive/2010/01/26/memory-considerations-about-powerpivot-for-excel.aspx) . I strongly recommend it.

The only additional point I would like to make is that the RTM version of PowerPivot has an additional check on the in-memory database when saving to disk.

Reading your #PowerPivot Profiler trace

Published January 30, 2010 Internals Leave a Comment
Tags: Excel, Troubleshooting

To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab within the PowerPivot Options & Diagnostics dialog. Click on the checkbox next to “Client tracing is enabled” and after opening the PowerPivot window, you will have a trace recorded on your desktop.

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’.

Published January 20, 2010 Configuration , Internals Leave a Comment
Tags: SharePoint, Troubleshooting

By Lee Graber (leegr@microsoft.com), on January 20th, 2010

A number of people have hit this issue and so it deserves a quick walkthrough of why it (unfortunately) can happen and how you fix it.

The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new site collections you create have the option to create a new document library of this type and if you use the PowerPivot Site template when creating the site collection, we automatically add a library of this type (that is the main thing we do in this template).

So i requested a PowerPivot workbook from SharePoint, what happens?

Published January 12, 2010 Configuration , Internals Leave a Comment
Tags: Excel Services, SharePoint

by Kasper de Jonge

In my previous blog posts we made use of a published PowerPivot workbook to use a datasource. In this post we are going to discover what goes on under the hood when you call a PowerPivot workbook on a SharePoint 2010 server.

Troubleshooting #PowerPivot Excel Services connectivity

Published November 18, 2009 Installation , Internals Leave a Comment
Tags: Connectivity, Data Refresh, Excel Services, SharePoint, Troubleshooting

You’re on your way to PowerPivot for SharePoint functionality – you’ve uploaded your PowerPivot for Excel workbook to your SharePoint PowerPivot Gallery. You view the thumbnails of your report and they look nice.

From the thumbnail, you click on the report you want to see, and the report renders nicely.

But then you click on a slicer, and then all of a sudden you get an error like the one below.

What can you do?

"That's how Morpheus rolls!" RT @powerpivotpro Down the rabbit hole: my new adventure revealed http://bit.ly/9c3PxC #PowerPivot 1 day ago
Oh dear, I never thought I'd hear #PowerPivot and Beavis & Butthead in the same blog RT @powerpivotpro: http://bit.ly/9neQ8i 2 days ago
Some of the HK BBQ in the city, eh?! (@ King's Barbeque House) http://4sq.com/cYgHd8 5 days ago
Ok, kiddo wanted her own iPhone, I'm in trouble! (@ Apple Store) http://4sq.com/8mC0GD 5 days ago
Back here so Izy can play on butterfly! (@ Childrens Play Area - University Village) http://4sq.com/9dxTlW 5 days ago

PowerPivot Twins!

Archive for the 'Internals' Category

Cannot add the specified assembly to the global assembly cache

The data connection uses Windows Authentication and user credentials could not be delegated

Dashboard Bubble Chart Shows a Red X (fails to load)

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook

Weird timer jobs

Memory Considerations in PowerPivot

Reading your #PowerPivot Profiler trace

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’.

So i requested a PowerPivot workbook from SharePoint, what happens?

Troubleshooting #PowerPivot Excel Services connectivity

RSS

Recent Posts

Tags

PowerPivot

Blogroll

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

Copyright

Archive for the 'Internals' Category

RSS

Recent Posts

Categories

Tags

PowerPivot

Blogroll

Copyright