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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.