Supported SQL Server versions

[Anonymous]

Hello guys and ladies,

I can't find an article with nice table which version of SQL server support what in Power bi, I was reading a while ago...

I remember, that for analysis live connection,  SQL server 2016 Standard is enough, with that sql version, you can also publish reports via PB gateway to cloud (Power BI pro)... Am I correct with this?

What about live connection to SQL database? Which version of sql server is minimum requred...?

Thanks for answers...

[v-yiruan-msft]

Hi @Anonymous ,

Please review the following documentations about Power BI data source prerequisites and the supported features of SQL Server 2016 per Edition:

Power BI data source prerequisites

Editions and supported features of SQL Server 2016

In addition, currently it supports only Import and DirectQuery connection mode when use SQL Server as data source. You can refer this official documentation to create and publish a report with SQL Server as data source.

Best Regards

Rena

[Anonymous]

Thank you for support. I was thinking about table bellow. I can't find link to original article...

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please review this documentation and check whether it is what you are looking for.

Best Regards

Rena

[Anonymous]

Thanks Rena...

This is article, I was looking for... I bookmarked it, so I'll never have to look for it again.. 🙂

[amitchandak]

@Anonymous , This is link https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

But it does not mention Db version

There was one for Direct Query, It is 2012/14 onward for direct Query and live is 2016 onward. But not able to find the link as of now.

https://community.powerbi.com/t5/Service/Direct-Query-with-SQL-Server-2017-Standard-Edition/td-p/380204