Category: BI

[Client-side Workaround] SharePoint 2010 Excel Services cannot Automatically Refresh Data when using SharePoint Lists as a Data Source

So far as I can tell, Excel Services is not capable of automatic data refreshes when using SharePoint Lists as a data source. If you’re looking for this functionality, you have two choices: PowerPivot (best) or scheduled client-side data refreshing

Posted in BI, PowerShell, SharePoint

SharePoint 2010: Creating Dashboards and Charts for SharePoint Lists using PerformancePoint and Excel Services from Start to Finish

I really thought making SharePoint Lists into pretty graphs and charts in SharePoint would be far more straightforward than it’s turned out to be. Recently, I was given a project where I had to do just that and while I

Posted in BI, SharePoint

[Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services

Recently, while using Excel Services to access PivotCharts and PivotTables within Excel Web Viewer Web Parts and PerformancePart Dashboards, I encountered vertical and horizontal scrollbars that would not go away, no matter how much I tried resizing. god don’t like

Posted in BI, SharePoint

[SOLVED] PowerPivot for SharePoint 2010: An error occurred connecting to this data source.

I’m currently working on a project where I need to quickly make pretty graphs and charts for data in small but important SharePoint lists. After looking through a number of books and consulting with my SharePoint buddies, PowerPivot for SharePoint

Posted in BI, SharePoint, SQL Server