cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niyati_61
Helper II
Helper II

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
Super User
Super User

 

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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!