topic Re: Power BI Report Server in Report Server

Power BI Report Server

niyati_61 — Tue, 02 Nov 2021 04:47:00 GMT

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!

Re: Power BI Report Server

FarhanAhmed — Tue, 02 Nov 2021 08:25:23 GMT

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

Re: Power BI Report Server

Anonymous — Thu, 04 Nov 2021 06:00:45 GMT

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.