Category: SharePoint

Passing parameters to Power View reports in SharePoint to force filter condition

  Here is an interesting article on how to pass a filter condition to a Power View report in SharePoint. One of the biggest complaints that I get as I demo Power View in SharePoint is its inability to save custom preferences for different user groups. In other words, if I have a dashboard built

Continue reading

How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot

In this post I will walk you through all the steps necessary to expose your on premise enterprise data to your Power BI users of Power Query in Excel and also will demonstrate how to source that data into a Power Pivot workbook. I am not going to give you too much theory, rather, I

Continue reading

PowerView can now connect to multidimensional models

The cumulative update 4 for the SQL Server 2012 Service Pack 1 has now been released. This update enables PowerView to connect to Multidimensional models and also to have global filters across multiple views (pages) in a PowerView report. Please follow this link for more details http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx

SAP vs. Microsoft, Information Assets vs. End User Experience positioning

If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle

Continue reading

SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView

In this post I will review the latest version of SAP Visual Intelligence – 1.08 – and see how it stacks up against the Microsoft self-service BI tools, Excel, PowerPivot and PowerView. In the initial release, Visual Intelligence only supported SAP Hana, but in its latest iteration few other data sources are supported: CSV File

Continue reading

Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models

I have had a pretty frustrating experience with it so far.  I think that the only way get it to work is to have it deployed as a SSRS Service Application inside SharePoint and then configure PowerView.  In other words, if you are planning to install a multidemensional instance of the CTP, install your OLAP cube

Continue reading

PowerView Feature Comparisons

PowerView experience will be delivered across several Microsoft products: Excel (fat client) Excel Services (SharePoint) SharePoint – SQL Edition Office 365 PowerPoint I get a lot of questions as to what features are supported across all these deployment scenarios. Luckily Microsoft shared a slide that I will attempt to reproduce here that explains what features

Continue reading

Microsoft Surface RT review, sort of in a context of Microsoft BI

First, I have to explain why I am writing this review when so many websites have already covered the product – the only thing that I will cover that others haven’t is what features of Microsoft BI stack run on Surface and what don’t. Let’s get through the bad stuff first. I don’t know if

Continue reading

Excel Services 2013 and SharePoint 2013 – interact with Pivot Tables using Browser

One of the nice new features of Excel Services now available in SharePoint 2013 is ability to interact with pivot tables directly from the browser without having to open the workbook in Excel. Here we have a PivotTable report deployed in SharePoint. Before, if we wanted to change a layout of the pivot table, we had to

Continue reading

More details on new PerformancePoint features in SharePoint 2013

Additional details are coming out on the new features that will be available in PerformancePoint 2013. Here is a list of new stuff: Themes – SharePoint has traditionally been somewhat of a challenge with respect to look and feel configuration and PerformancePoint Services was an even bigger challenge yet. Microsoft has simplified the CSS challenges

Continue reading