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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
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
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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