Fix “login failed” error while editing Table Properties in SSAS Tabular via Visual Studio

Just a quick post regarding a strange problem I encountered while working on an SSAS Tabular model project.  Built on the same Vertipaq technology as Power Pivot, it’s very easy to get started and produce quick, efficient data models.  Unlike Power Pivot, which runs as an Excel add-in, SSAS Tabular models are developed in Visual Studio via the SQL Server Data Tools (SSDT) Business Intelligence add-on.  However, once you load up the development environment, it’s almost exactly the same, the only difference really being that when you build a tabular model in VS, it is developed against a temporary cube on a pre-installed SSAS Tabular instance.  Power Pivot just works entirely in memory, without requiring an SSAS instance.

Continue reading “Fix “login failed” error while editing Table Properties in SSAS Tabular via Visual Studio” »

Microsoft announces Power BI for Office 365

After launching a number of really neat self-service business intelligence plugins and components over the past couple of years, Microsoft has finally announced their complete self-service BI package: Power BI for Office 365.  Incorporating Microsoft’s four big self-service BI components of the past year or so; PowerPivot, PowerView, Data Explorer and GeoFlow, the Power BI suite combines these parts into a single, unified offering.  Most exciting of all though, is the inclusion of a mobile application for either Windows (I’m assuming Win 8) or iPad, which could very well be the secretive “Project Helix”, revealed at last year’s SharePoint Conference. Continue reading “Microsoft announces Power BI for Office 365” »

Screenshot showing chart editing in SSRS Report Builder

5 Reasons why PowerView can’t replace Reporting Services

The other week I wrote a post discussing how PowerView was the future of SQL Server Reporting Services, and the killer features that made it a compelling choice.  Despite the numerous positive advances that PowerView brings to Microsoft/SQL-based reporting, there are of course a number of counter arguments.  I deliberately left these out in order to look at some of these reasons in a later post.

As such, here are five reasons why PowerView, despite all its pizzazz, is simply not capable (in its current form) of replacing the venerable SSRS. Continue reading “5 Reasons why PowerView can’t replace Reporting Services” »

Screenshot of PowerView in Excel 2013

6 Reasons why PowerView is the Future of Reporting Services

Since its introduction with SQL Server 2012, PowerView has started to become the familiar face of Microsoft’s self service business intelligence offering.  Its inclusion in Excel 2013 has only reinforced its position as the premier tool for quick, interactive  visualisation of data, in conjunction of course with the magnificent PowerPivot.  But ask any “traditional” BI developer/architect about Reporting Services (SSRS), and it’s likely that they will staunchly defend it, decrying PowerView as a gimmick.

So here are 6 reasons why PowerView is NOT a gimmick, and may in fact be the future of SQL Server Reporting Services. Continue reading “6 Reasons why PowerView is the Future of Reporting Services” »

SQL Server Management Studio standalone download

Screenshot of SSMS 2012 Express in action

SSMS 2012 Express is available as a standalone download

Something I see online all the time, is people trying to find a standalone download for SQL Server Management Studio.  Until recently, it seems, Microsoft certainly didn’t make it easy to just install the client tools without having to install the entire SQL Server database engine as well.  The are plenty of reasons why you might want to install just the client tools and not the database engine on your computer, after all, in this world of self-service business intelligence, it’s no longer just developers and DBAs who are playing with data directly.

Fortunately, with SQL 2012 Express, you have a wide variety of download options, ranging from a standalone version of SSMS Express, to SQL Express (including SSMS), with Reporting Services  and Full Text Search.

Check out http://www.microsoft.com/en-us/download/details.aspx?id=29062 to download SSMS as a standalone component.