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

Ideal Pages and Size of Report

Dear team, 

 

I need a small suggestion from you all. 

I am currently working on a project which will monitor live daily data. An excel sheet for each data will be added in folder path.

 

Properties of one excel file:

Size: 530kb

Sheets used: 4

Columns: 13

Rows:206

 

 

As of now, I have 15pages in my report. What can be the maximum page limit so that report does not take too long to load and display data?

 

Questions:

1. Can I have a report of 25-30pages? Will the loading time be affected?

2. What is the maximum folder size as daily if I am adding a file of 500Kb, then in a month only it will be close to 16mb. Is there a source folder size limit?

3. What can be the maximum number of rows Power Bi supports as my daily file adds 206-210 rows?

 

Thanks in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , there no such limit may be 250 pages.

 

The limit in terms of size is user workspace 1 GB for free, 10 GB for Pro. I think 100 TB for premium

 

Max row in term of the direct query is limited 1M per query

 

 

References:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-manage-your-data-storage-in-power-bi...

https://community.powerbi.com/t5/Desktop/Number-of-records-limitation/td-p/9552

https://community.powerbi.com/t5/Desktop/Power-BI-10-000-rows-limit-Question/td-p/17715

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , there no such limit may be 250 pages.

 

The limit in terms of size is user workspace 1 GB for free, 10 GB for Pro. I think 100 TB for premium

 

Max row in term of the direct query is limited 1M per query

 

 

References:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-manage-your-data-storage-in-power-bi...

https://community.powerbi.com/t5/Desktop/Number-of-records-limitation/td-p/9552

https://community.powerbi.com/t5/Desktop/Power-BI-10-000-rows-limit-Question/td-p/17715

Anonymous
Not applicable

@amitchandak @parry2k 
At present I have 25 pages in my report which may go as high as 35-40.

size of report as of now is 1286kb which may go as high as 2MB.

 

Will that size be normal and ideal or it can create increased loading time or other issues?

Please suggest.

 

Thanks in advance

Anonymous
Not applicable

Thankyou @amitchandak for the quick response. 

 

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.