Yes, it is totally possible to publish a SSRS report into your PowerPivot Gallery – In fact, the gallery invites you to do so with the “New Report Builder Report” item in the PowerPivot gallery’s silverlight application. But as my buddy George Orwell might say, “All reports are equal, but some reports are more equal than others.” Essentially, you’re not going to get a snapshot generated for your SSRS reports stored here. The [ Read More ]
If you’ve played with PowerPivot at all, it’s pretty obvious how flexible the tool is in terms of creating data models. After you initially create a model, you may want to spend some additional time with it to make sure users can easily leverage what
File this under “duh”, but if your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then…. Hide those chart data sheets, ladies! Simple, but makes a world of difference in terms of how cool your re
Want to play with PowerPivot (Project Gemini) without going through the hassle of installing Office, SharePoint, etc? Try the newly released virtual lab! https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d Upda
I had a bear of a time getting SQL Server 2008 R2 November CTP’s Integrated PowerPivot feature installed. It looks like several other people in the Twitter/Blogosphere are running into the same issue, but for potentially different reasons. For m
I was in an inflammatory mood at the beginning of the week and tweeted the following at #sqlpass: DBAs don’t like it, but Excel IS the database for many. This hasn’t and won’t change. Manage to this reality. The
Last week I was in a bit of a panic when Excel Services and SQL Reporting Services (MOSS Integrated) broke on nearly all of my “demo” Hyper-V images. I could publish to Excel Services, but attempting to render caused this exception to get
