Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
niyati_61
Helper III
Helper III

Power BI Report Server

Hello all,

 

My company is going to install SQL Server Enterprise Edition 2019 with Software Assurance. We are doing this mainly as we need to get access to the on-premises reporting - Power BI Report Server. 

 

Once we install the SQL Server in the dektop, I require guidance on the installation/ configuration process for Power BI.

 

Can anyone please provide a step by step guide on what to do once the SQL Server is installed by Microsoft Vendor in the system? How do you access the Power BI Report Server from there?

 

Also, will we have access to SSRS on the SQL Server as well? How is SSRS reporting different from Power BI Report Server?

 

Thanks in advance!

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@niyati_61 

Please refer to the the step by step guide to configure the server:
Install And Configure Power BI Report Server Step By Step (devoworx.com)

 

You can install both server, they have a slight difference. Basically power BI is comparatively more graphical and modern, whereas SSRS requires more time and manual effort to analyze data and generate reports. 

Power BI Vs SSRS | Key differences between SSRS & Power BI (intellipaat.com)

 

And it is worth to know that you can migrate reports from SSRS to PBIRS that requires Power BI Premium license.

Migrate SQL Server Reporting Services reports to Power BI - Power BI | Microsoft Docs

 

 

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@niyati_61 

Please refer to the the step by step guide to configure the server:
Install And Configure Power BI Report Server Step By Step (devoworx.com)

 

You can install both server, they have a slight difference. Basically power BI is comparatively more graphical and modern, whereas SSRS requires more time and manual effort to analyze data and generate reports. 

Power BI Vs SSRS | Key differences between SSRS & Power BI (intellipaat.com)

 

And it is worth to know that you can migrate reports from SSRS to PBIRS that requires Power BI Premium license.

Migrate SQL Server Reporting Services reports to Power BI - Power BI | Microsoft Docs

 

 

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

FarhanAhmed
Community Champion
Community Champion

 

Hi, 

you can follow these articles 

 

If you have a SQL Server Enterprise SA agreement, you can get your product key from the Volume Licensing Service Center

Ref: How to find your report server product key - Power BI | Microsoft Docs

 

 

Install Power BI Report Server - Power BI | Microsoft Docs

Power BI Report Server vs SQL Server Reporting Ser... - Microsoft Power BI Community

 

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.