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
ltendam
Frequent Visitor

Is there a size limitation on datasets when using live data connection

Is there a max size on datasets when using a live data connection. When using Azure SQL Database or SQL Database as live data connection. 

 

I read some information about a max file size of 250MB but is this also for live connections?

 

Regards,

 

ltendam

1 ACCEPTED SOLUTION
greggyb
Resident Rockstar
Resident Rockstar

The 250MB file size limit is for a hosted Power BI data model (import data to .pbix and upload to Power BI Service). When using either of DirectQuery (relational sources) or Live Explore (SSAS sources), your only limits are based on the resource of the server (SQL Server, Azure SQL, SSAS server, etc) hosting the source data.

View solution in original post

1 REPLY 1
greggyb
Resident Rockstar
Resident Rockstar

The 250MB file size limit is for a hosted Power BI data model (import data to .pbix and upload to Power BI Service). When using either of DirectQuery (relational sources) or Live Explore (SSAS sources), your only limits are based on the resource of the server (SQL Server, Azure SQL, SSAS server, etc) hosting the source data.

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.

Top Solution Authors