Tag Archives: powerpivot

Unauthorized when using SharePoint PowerPivot document from Report Builder or Excel?

Here is the scenario: You’ve got WFE Server which is also an app server with PowerPivot set up, we’ll call it SPWFE. You also have the database server which is a SharePoint database, let’s call it SPDB. That same server … Continue reading

Posted in sharepoint, sharepoint 2010 | Tagged , , | Comments Off

Troubleshooting PowerPivot: Unable to refresh data for a data connection in the workbook

If you’re trying to explore one of the cool new integrations in SharePoint 2010 BI stack, PowerPivot, you might run into the problem where your PowerPivot workbooks will return the following error, when you try clicking on the slicer in … Continue reading

Posted in sharepoint | Tagged , | Comments Off