Forum Discussion
Supported SQL Server versions
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...
Hi Anonymous ,
Please review this documentation and check whether it is what you are looking for.
Best Regards
Rena
5 Replies
- amitchandak
Super User
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.
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
Hi Anonymous ,
Please review this documentation and check whether it is what you are looking for.
Best Regards
Rena
