Microsoft BI (Build up PowerView Reports) SQL Server 2012 PowerPivot for SharePoint 2010 works in iPad 2, iPhone 4S, Windows 8 Tablets, Windows Phone 7.5 & SmartPhones

The latest interactive BI tool of SQL Server 2012 is PowerView Reports which runs as an integrated Reporting Services app of SharePoint 2010. The PowerView Reports provides interactive support for Bubble Charts, Line Graphs along with the Matrix, Cards support having Metro Style UI approach.

Lets build an app to consume Windows Azure Data Market feed API on Excel PowerPivot . So, open Excel PowerPivot & select Azure DataMarket Feed API.

  • Lets Sign up for the Data Feed from Azure MarketPlace & get the dataset Atom feed URL. You need to provide the Account Key.

  • Lets populate the Azure DataMarket Feed data on Excel PowerPivot & develop the PivotCharts to analyse the World Health Statistical Analytics.

  • Now, save the Excel sheet & send it to SharePoint PowerPivot Gallery where we can start to build the PowerView Reports.

  • Lets run the PowerView report build on SharePoint 2010 on iPhone 4S device & check the PowerView reports run on iPhone , iPad , Windows 8 tablets, Windows Phone , Android & all smartphones.


About Anindita
Anindita Basak is working as Big Data Cloud Consultant in Microsoft. Worked in multiple MNCs as Developer & Senior Developer on Microsoft Azure, Data Platform, IoT & BI , Data Visualization, Data warehousing & ETL & of course in Hadoop platform.She played both as FTE & v- employee in Azure platform teams of Microsoft.Passionate about .NET , Java, Python & Data Science. She is also an active Big Data & Cloud Trainer & would love share her experience in IT Training Industry. She is an author, forum contributor, blogger & technical reviewer of various books on Big Data Hadoop, HDInsight, IoT & Data Science, SQL Server PDW & PowerBI.

4 Responses to Microsoft BI (Build up PowerView Reports) SQL Server 2012 PowerPivot for SharePoint 2010 works in iPad 2, iPhone 4S, Windows 8 Tablets, Windows Phone 7.5 & SmartPhones

  1. luisrh says:

    Anindita – Quick question. Power View is a sliverlight app. How are you able to render it on the Ipad and Iphone. I was under the impression that MSFT was going to release something soon that ran on HTML5 and would be able to be seen on all devices – is that what you are using, because on my current version of Power View (which is part of Sql Server 2012 release) I am not able to do what you are showing above. Could you please point me to what I may be doing wrong? Or is the Iphone emulator showing something incorrect above.

    • imcuteani says:

      Hi Lurish,

      First of all , although PowerView reports are Silverlight apps but still it works perfectly on any smart devices platform (e.g iPhone, iPad, Windows 8, Windows Phone 7.5). On the SQL Pass summit 2011 , the PowerView team already annouced it & published a video also on it.
      You can use any standard iPhone emulator for iOs on your system to view the PowerView reports from SharePoint.

      Let me know if you face any issues.


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: