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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors