Power BI : What's the Limitation Power BI with MSSQL Express !?

 To able to answer this question we need to clarify Which power BI component (Power BI Desktop Or Power BI Report Server) and what's purpose.

Need to connect to MSSQL Express to bring the data?

Power BI Side,

you will able to connect using Direct Query Or Import Type 

MSSQL Side,

But there are many Limitations will be from the MSSQL Express itself as below

1. 1GB maximum memory used by the database engine
2. 10GB maximum database size
3. 1MB maximum buffer cache
4. CPU the lesser of one (1) socket or four (4) cores (number of SQL user connections NOT limited)

Note!

---

To know more about the other limitations and compare with other versions Click here

Build Power BI Environment,

For build a Power BI Environment it requires MSSQL Enterprise license to configure the Power BI Report Server