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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Limitations on Power BI with SQL Server Express?

We have a customer running data on a SQL Server Express (2014). 

If we want to user PowerBI based on this server, can we expect any limitations?

 

Thking of the user of DIrectquery and other limitations.

 

What are your experiences?

 

Thanks for the feedback!

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

You are ok to connect to SQL Server 2014 Express edition from Power BI Desktop using the DirectQuery option. The limitation exists in SQL Server 2014 Express itself and the DirectQuery mode in Power BI.

For SQL Server 2014 Express, it has the following limitations. And Agent Service is not available in Express edition.
   • 1 physical processor
   • 1 GB of RAM
   •10 GB database size per database

Besides, there are currently a few limitations (such as the following points) to using DirectQuery in Power BI Desktop, these limitations will also exist when you connect to other editions of SQL Server 2014 by using “DirectQuery” option.

   •All tables must come from a single database
   •Relationship filtering is limited to a single direction, rather than both directions
   •By default, limitations are placed on DAX expressions allowed in measures

For more details about limitations of DirectQuery, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ .

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
bz_arsis
Frequent Visitor

So is it not possible to create PowerBI Books in Import-Mode then?

Because you are saying we can only connect in DirectQuery mode?

Thank you for claryfication,

Beat

 

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

You are ok to connect to SQL Server 2014 Express edition from Power BI Desktop using the DirectQuery option. The limitation exists in SQL Server 2014 Express itself and the DirectQuery mode in Power BI.

For SQL Server 2014 Express, it has the following limitations. And Agent Service is not available in Express edition.
   • 1 physical processor
   • 1 GB of RAM
   •10 GB database size per database

Besides, there are currently a few limitations (such as the following points) to using DirectQuery in Power BI Desktop, these limitations will also exist when you connect to other editions of SQL Server 2014 by using “DirectQuery” option.

   •All tables must come from a single database
   •Relationship filtering is limited to a single direction, rather than both directions
   •By default, limitations are placed on DAX expressions allowed in measures

For more details about limitations of DirectQuery, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ .

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors