cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Elena Frequent Visitor
Frequent Visitor

Technical Preview of Power BI Reports in SQL Server Reporting Services

Just had a chance to play with the Technical Preview of Power BI Reports in SQL Server Reporting Services. You can set up the VM yourself or download the updated Virtual Machine from Azure Marketplace.

 

I set up my own Virtual Machine and what you need is an instance of SQL Server 2016 or SQL Server vNext CTP v1.1. Also install Analysis Services Tabular or Multi-dimensional mode and sample database for the same.

 

Note: The preview version supports only Power BI Dashboards connected to Analysis Services on-premises otherwise you will get the following error.

 

PowerBIPreviewError

 

It comprises of 3 files

  • PBIDesktopRS.msi
  • PBIDesktopRS_x64.msi
  • SQLServerReportingServices.msi

Install the SQL Server Report Services and use the SSRS Preview Configuration Manager to create the Report Server Database.

 

PowerBIPreviewRSConfig

 

Note: You will be seeing Create Database button in the screenshot similar to the above instead of Change Database. The above screenshot was taken once the Database was created.

 

Install the Power BI Desktop for Reporting Services 64-bit version and create a Power BI Report connected to your Analysis Services Database. Upload your new Power BI Report created using the Preview version of Power BI Desktop to the SSRS Portal and try navigating to the report.

 

PowerBIPreview1

 

PowerBIPreview2

 

As you can see from the above screenshot, Power BI report opens within the SSRS Portal Browser window.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Technical Preview of Power BI Reports in SQL Server Reporting Services

Hi @Elena,

 

There is a new Power BI report server version August 2017 (preview) which supports imported data. You can download it from here. See: What's new in Power BI Report Server

 

Best Regards,
Qiuyun Yu 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Technical Preview of Power BI Reports in SQL Server Reporting Services

Hi @Elena,

 

There is a new Power BI report server version August 2017 (preview) which supports imported data. You can download it from here. See: What's new in Power BI Report Server

 

Best Regards,
Qiuyun Yu 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 148 members 1,579 guests
Please welcome our newest community members: