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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
kaarel
Resolver I
Resolver I

SQL Standard 2016, Tabular Model with Live Connection?

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.