Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi!
I know that connecting from PowerBI to SSAS MD requires SQL Enterprise Edition, With SQL 2016 Standard upto 16GB Tabular model is supported. Will this work with PowerBI live connection?
Thanks,
Kaarel.
Solved! Go to Solution.
Hi @kaarel,
It will work that use the live connection to Tabular Model of SQL Server 2016 Standard edition in Power BI, there is no restriction on the SQL Server editions as long as they support Tabular Model. For more details, please check the following articles.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analysis-services-tabular-data/
https://powerbi.microsoft.com/en-us/documentation/powerbi-sql-server-analysis-services-tabular-data/
Thanks,
Lydia Zhang
Hi @kaarel,
It will work that use the live connection to Tabular Model of SQL Server 2016 Standard edition in Power BI, there is no restriction on the SQL Server editions as long as they support Tabular Model. For more details, please check the following articles.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analysis-services-tabular-data/
https://powerbi.microsoft.com/en-us/documentation/powerbi-sql-server-analysis-services-tabular-data/
Thanks,
Lydia Zhang
That is awsome news. Thanks!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!