There are several UI gotchas related to building PowerView visualizations that I wanted to address with this post. First, PowerView is not available in the Ribbon out of the box, in order to enable it, one needs to go to File->Options->Add-ins. Then find Manage Add-Ins drop down box, select "COM Ad-ins" and click Go. That … Continue reading How to connect Excel PowerView to Analysis Services cube
Category: Excel and Excel Services
PowerView in Excel 2013 – Business Intelligence – Second Impression
Well, the more time passes, the more I like it... Somehow I have figured out, subconsciously, how not to make it crash quite as often and also how to work around things that don't work very well. So, in no particular order, here are few more observations... Map - like it a lot. There is … Continue reading PowerView in Excel 2013 – Business Intelligence – Second Impression
Excel 2013 – Business Intelligence – First impressions
I have been playing with the new excel for a few weeks now and I think I have finally enough material to share. In general the first impressions can be bucketed in three distinct set of emotions: Wow - a lot of new cool stuff coming out. It is becoming painfully clear that the PerformancePoint … Continue reading Excel 2013 – Business Intelligence – First impressions
How to limit values in PivotTable filters in Excel
Excel 2010 is tightly integrated with SharePoint which allows users to author their reports in Excel and then simply save them in SharePoint so that they can be subsequently rendered to everybody else as a web page using Excel Services. Unfortunately, not all features of Excel can be rendered; some of them generate warnings but … Continue reading How to limit values in PivotTable filters in Excel
business intelligist 