Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Premium - which SQL server edition for catalog ?

Hi all,   My organization recently bought Power BI premium. Now i'm installing the Reportserver and i am at the point of installing the reportserver catalog databases. I will use a dedicated sql se...
Express
ReportServer
SQL Server Edition
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

 Can I use SQL Server 2017 Express Edition or other free version for the Reportserver databases?

Yes. You can use SQL Server free version to host Power BI Report Server database.

 

I guess someone says "Enterprise edition is needed" might mean if you have purchased SQL Server Enterprise Edition + Software Assurance, then, you don't need to purchase Power BI Report Server product key separately.

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yulgu-msft ,

 

Thanks for your response. Good to hear its possible to use the free SQL edition. Is advanced features necessary?

Furthermore, Express has 10 GB size limitation. We're starting to use PBIRS so the data will grow and in the beginning Express will be sufficient I guess. But is it 'smart' to use Express Edition ? No sql server agent, no automatic backups.. Introducing Power BI into the organization is very important, so i would like to have a good start.

 

Kind regards.