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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.