Power BI Reports in SQL Server Reporting Services

Hello Everyone !!! Technical Preview of Power BI reports in SSRS is now available. The setup files are available for download in the link below.

Download Link: https://www.microsoft.com/en-us/download/details.aspx?id=54610

What does the download link include?

  • Preview version of Power BI Desktop setup
  • Preview version of Microsoft SQL Server Reporting services

You will need to use the Technical Preview version of Power BI Desktop only for this exercise. If you already have any other version of Power BI Desktop, you can install this one too by the side.

What can you do with Technical Preview Version of Power BI Desktop?

  • “Live” connections with Analysis Services (Both Tabular and Multidimensional)
  • Create a Power BI report and save it on your report server. (Report server must be running the Technical Preview)
  • Interact with the report in web browser.

Getting Started !!!

Download the setups from the link above.download-link

  • Install both the setups.

pbi-installation

ssrs-installation

  • Open Power BI Desktop (SQL Server Reporting Services)

pbi-ssrspbi-blank-report

  • Select Analysis Services database as your datasource as of now.
  • Create a report and save it.

pbi-ssrs-report

  • Open your Report Server.

pbi-ssrs-upload

  • Upload the pbix file.

pbi-ssrs-uploaded

  • On clicking the uploaded pbix file you can see the report on the web browser.

pbi-ssrs-report-web

  • This is very similar to the “Publish to web” feature of Power BI.

Other useful links

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/12/16/power-bi-reports-in-sql-server-reporting-services-feedback-on-the-technical-preview/

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/10/25/announcing-a-technical-preview-of-power-bi-reports-in-sql-server-reporting-services/

https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/01/18/getting-started-with-the-technical-preview-of-power-bi-reports-in-sql-server-reporting-services/

Enjoy Reporting !!!

 

Advertisements

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