Category: Reporting Services

SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download

SSDT-BI were down for almost a month after the release of the SQL Server 2014 causing a lot of frustration to the end users who were trying to develop BI solutions using Visual Studio 2013. No point of getting into the reasons why, let’s just take a deep breath and download the latest version here

Continue reading

Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the

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

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

SQL Reporting on Azure goes GA, PowerView not available in cloud

Microsoft has just announced that Windows Azure SQL Reporting is Generally Available.  A quick glance on the Guidelines and Limitations reveals that the released functionality is mainly based on the SQL Server 2008 R2 stack, which means that PowerView is not available in the cloud yet.

PowerView in Windows 8 Release Preview

I was eagerly awaiting the new Release Preview of Windows 8 as I was hoping it would address some of the shortcomings with respect to the Microsoft BI Stack and Windows 8 that I blogged about before.  One of the new features introduced in to the IE 10 was Flash support.  I have not read

Continue reading

HTML5 support for PowerView and the rest of the Microsoft BI stack

Had a long conversation with a senior Microsoft executive few days ago.  It appears that HTML5 support for PowerView will be released with the Service Pack 1 for SQL Server 2012 by the end of this calendar year.  A little too late for my taste, but I will take what I can get.  My prognostication is

Continue reading

SharePoint on iPad

Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser.  Not all visualizations are supported: Visualization Type Renders on iPad Dashboards (filters, linked elements) YES Excel Services (including PPS webpart) YES Reporting Services (including PPS webpart) NO PerformancePoint ScoreCards YES

Continue reading

Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard

One of the greatest strengths of SharePoint as it pertains to the world of Microsoft Business Intelligence is its ability to bring together various components of the Microsoft BI stack into a seemless user experience. When it works, it works great, however, when it does not quite work, it gets very annoying.. Recently, I was

Continue reading