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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
EladK
Regular Visitor

power bi report server with sql server enterprise edition - load data from sql server standard edi.

Hi,

We deserve power bi report server license because we purchased sql server enterprise edition with SA.

But, our source data is splitted between several sql servers, some of them are sql server standard edition.

Can we load source data from the sql server standard edition as well (or we can load data from the sql server enterprise edition only)?

Thanks, Elad.

 

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

The cores for the server where you install Report Server need to be coverd by SQL Enterprise with SA.

 

But you can source data for reports from multiple other SQL Servers (and even other database providers if you need). From a Report Server perspective it does not matter how those other servers are licensed.

 

 

View solution in original post

1 REPLY 1
d_gosbell
Super User
Super User

The cores for the server where you install Report Server need to be coverd by SQL Enterprise with SA.

 

But you can source data for reports from multiple other SQL Servers (and even other database providers if you need). From a Report Server perspective it does not matter how those other servers are licensed.

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.