Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Happy Birthday Power BI

Today marks the first anniversary of Power BI Desktop and the Power BI Service.  The effort to achieve this milestone and the on-going commitment of the teams responsible for this product is nothing short of phenomenal.  Earlier this week, I reached out to a few friends to join me in…

Read more

1 comments, 115 reads

Posted in SQL Server BI Blog on 24 July 2016

SSRS 2016 Book Nearly Done… My Brain is now Jell-O

(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content complete!  The book is well into the editing stage– still, another grueling phase of the publishing process, but there is light at the end of the proverbial tunnel.  What is…

Read more

4 comments, 140 reads

Posted in SQL Server BI Blog on 20 July 2016

What do you want to learn about SSRS 2016 at PASS Global Summit?

I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016: The Force Awakens”.  I’ve been speaking at SQL Saturdays and have done some training on SSRS 2016 this year but this new session has yet to be finished SO…. please…

Read more

7 comments, 821 reads

Posted in SQL Server BI Blog on 24 June 2016

Using Power BI with Enterprise, On-premises Data

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data.  The running time for all four parts is about 44 minutes.  I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources:  SQL Server database connected with…

Read more

2 comments, 272 reads

Posted in SQL Server BI Blog on 19 June 2016

Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016

A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling role-based, row-level security.  This feature doesn’t require complex administration configurations, service principal delegation, Kerberos, Claims/Windows Token conversion or impersonation.  You may not be as excited as I am about this…

Read more

2 comments, 1,008 reads

Posted in SQL Server BI Blog on 13 June 2016

Where are SQL Server 2016 Client Tools?

So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools and all the components you needed.  You look for SSMS and, what the heck?  it’s not there.  OMG, what have they done?! SSMS is Gone! Seriously, SQL Server Management Studio…

Read more

2 comments, 313 reads

Posted in SQL Server BI Blog on 27 May 2016

Power BI Application Embedding Releases Today

A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and other capabilities into a web frame for all the world to see.  The next natural step, you might think, would be a way to to securely embed selected Power BI…

Read more

1 comments, 213 reads

Posted in SQL Server BI Blog on 1 April 2016

Color Themes for Power BI

Color coordination is important in report and dashboard design.  We’ve seen theming and color pallet options in the prior iteration of Power BI but this is not yet a feature in the new version. No doubt, the product will continue to move forward and we’re likely to see some kind…

Read more

12 comments, 328 reads

Posted in SQL Server BI Blog on 22 March 2016

Annual Business Intelligence Survey

This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research.  I’ve been participating in the survey for several years (as far as I know, as long as it has been running).  As a participant, I receive a detailed copy of the results which are…

Read more

1 comments, 229 reads

Posted in SQL Server BI Blog on 15 March 2016

Article Series: Power BI Solutions for the Enterprise

I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published this past week in SQL Server Pro Magazine.  I will republish the completed series but until then, I’ll post short excerpts from each article.  In future posts, I’ll show examples…

Read more

6 comments, 282 reads

Posted in SQL Server BI Blog on 28 February 2016

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes.  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant for Business Intelligence and Analytics Platforms, as of February…

Read more

4 comments, 290 reads

Posted in SQL Server BI Blog on 5 February 2016

Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016

Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ If you’re still on SQL Server 2005, there are some important things to be aware of.  First and foremost is that you are missing out on innumerable capabilities in more…

Read more

0 comments, 312 reads

Posted in SQL Server BI Blog on 26 January 2016

Tabular Models, Multiple Data Sources and Unknown Members

Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from multiple data sources.  I’m including SSAS Tabular on the “self-service” list because it is derived from Power Pivot and often used for “quicker” IT-managed BI projects.  The alleged advantage of…

Read more

5 comments, 356 reads

Posted in SQL Server BI Blog on 29 December 2015

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for every function.  This is useful but you can’t view all of the functions in one searchable page.  If you don’t know exactly what you’re looking for, it can be a…

Read more

5 comments, 323 reads

Posted in SQL Server BI Blog on 26 November 2015

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other BI features? I was recently interviewed for a CIO Magazine article by freelance writer Andy Patrizio about what the end of support means for CIOs.  Thanks to the SQL Server…

Read more

0 comments, 1,674 reads

Posted in SQL Server BI Blog on 24 November 2015

The Resurrection of Reporting Services & The Maturing of Power BI

Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal firehouse of information about the Microsoft BI platform.  I’ve participated in the PASS Summit for twelve years and the MVP Summit for seven years thus far and in that time,…

Read more

13 comments, 276 reads

Posted in SQL Server BI Blog on 12 November 2015

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President who leads that team will be speaking live…

Read more

1 comments, 274 reads

Posted in SQL Server BI Blog on 2 October 2015

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President who leads that team will be speaking live…

Read more

1 comments, 101 reads

Posted in SQL Server BI Blog on 2 October 2015

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been running for about two weeks and wraps up on October 1. The first people's choice award winner is Daniele Perilli from Rome who submitted a nice horizontal bullet chart. The…

Read more

3 comments, 156 reads

Posted in SQL Server BI Blog on 22 September 2015

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been running for about two weeks and wraps up on October 1. The first people's choice award winner is Daniele Perilli from Rome who submitted a nice horizontal bullet chart. The…

Read more

3 comments, 602 reads

Posted in SQL Server BI Blog on 22 September 2015

Older posts