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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
EladK
Regular Visitor

Tabular installation to be used with power bi report server

Hi,

We currenty have power bi report server installed in a separeted server.

We would like to add Tabular to work with the power bi report server.

What is the cheepest sql server edition we can use? (to be installed on the power bi server)

We can't install the power bi report server on the sql server that contain the source data.

We have power bi report server available through the purchase of sql server enterprise edition with SA.

Thanks, Elad.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@EladK wrote:

What is the cheepest sql server edition we can use? (to be installed on the power bi server)

The standard edition is the cheapest edition that supports running a tabular instance

 


@EladK wrote:

(to be installed on the power bi server)

We have power bi report server available through the purchase of sql server enterprise edition with SA.

 


If you are licensing Report Server using SQL Enterprise with SA and you want to install a tabular instance on that server then those cores should already be covered by the SQL Enterprise license so you should not need any existing licensing. 

 

Note that it is generally not recommended to run heavy workloads like Tabular and Report Server on the same hardware, but it can work for smaller environments.

View solution in original post

1 REPLY 1
d_gosbell
Super User
Super User


@EladK wrote:

What is the cheepest sql server edition we can use? (to be installed on the power bi server)

The standard edition is the cheapest edition that supports running a tabular instance

 


@EladK wrote:

(to be installed on the power bi server)

We have power bi report server available through the purchase of sql server enterprise edition with SA.

 


If you are licensing Report Server using SQL Enterprise with SA and you want to install a tabular instance on that server then those cores should already be covered by the SQL Enterprise license so you should not need any existing licensing. 

 

Note that it is generally not recommended to run heavy workloads like Tabular and Report Server on the same hardware, but it can work for smaller environments.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.