Configuring Power BI Integration with Reporting Services


SQL Server Reporting Services (SSRS), the de-facto reporting tool in the Microsoft business intelligence stack has been losing attention while its cousin Power BI, has been stealing the limelight with updates and goodies coming out at a regular pace. While, Power BI is a nice little tool for flashy reports and dashboards, it lacks the features to build complex reports. But that is just how Power BI is meant to be used. But once in a while there comes a requirement where someone might think that it would be nice to have a portion of an SSRS report pinned onto a Power BI dashboard – SQL Server 2016 makes this possible.

When configuring Reporting Services in SQL Server 2016 (I’ve noticed it beginning CTP3) using the Reporting Services Configuration Manager, you will see a new tab for Power BI Integration.

SSRS_PowerBI_Configuration_01

SSRS_PowerBI_Configuration_01

All you have to do is hit the Register with Power BI button and sign in to your Power BI account, and you are registered!

SSRS_PowerBI_Configuration_02

The next post on this theme would be more in-depth where I’ll get into the next steps…

Advertisements

One thought on “Configuring Power BI Integration with Reporting Services

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s